Forum Discussion
Custom year slicer
Hello, I have a year slicer in which there are 4 years. For this current year i have used dax which is: YearSlicer = if([Year]=year(today()),"Current Year",CONVERT([Year],STRING)). But th...
Understood 🙂
Would you be willing to use the "Slicer (new)" visual?
It would require the items to appear as buttons.
If you have a "Year Offset" column, you could place a "Year Offset" field on the slicer, filtered to zero (i.e. current year)
Then switch off Values (-3, -2, -1, 0) and instead show a Label defined by a measure returning the year (2020, 2021, 2022, 2023).
Example attached.