1 of 1 people found this helpful
Create parameter with list of years.
Create calc as
[Order Date Parameter]=year([Order Date]) or [Order Date Parameter]= YEAR([Order Date])+1
Drag this calc into filter and select true.
Show parameter control and select any year and get current and previous two year in view.
Thank you Sankar, this is really helpful!
Now that I have this working I have another challenge. Some of the other charts on my dashboard only need to display the selected year - i.e. not show the previous year. Is there a way to control the filter on those charts with the filter you've described.
So I'd have two filters - one shows only the selected year, the other shows the selected year plus the previous year. Selecting a year on one of the filters would select the same year on the other one.