Forum Discussion

Sanskruti's avatar
Sanskruti
Icon for Helper II rankHelper II
2 years ago

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...
Need Help
Show and Tell
AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
2 years ago

Why don't you just select the current year in the default published report? And set a hidden page filter with the last three years plus the current one? 

And just change this setting once per year, on January 1st?

Sanskruti's avatar
Sanskruti
Icon for Helper II rankHelper II
2 years ago

thanks for replying AliceW ,
We tried this method but this will not be a good practice.