Filter Only Display Last 3 Financial Years

DAX DAX Calculations
1

I have data going back to 2010 in a sales table.

i have a filter with FY.

I only want the filter to display FY 2019, FY 2018 and FY 2017 for all reports

any ideas ? it might be simple but cant seem to only display those 3 years.

2

ok think i found the problem. i have 3 reports and using bookmarks.

i used the report level filter on all pages and changed to FY 2017, FY 2018 and FY 2019.

when i clicked the bookmarks and went back to various pages it was reseting the filters.

so i right clicked on each bookmark and unclicked data and then update.

now it doesn’t reset the filters.

just wanted to share in case others were having the same problem

3

Nice catch on that one.