Forum Discussion
Sanskruti
Helper II
Helper IICustom 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...
OwenAuger
Super User
Super UserYes, as long as the dataset is refreshed so that Year Offset column = 0 for the current year.
The slicer selection is actually Year Offset = 0. It just displays the appropriate year as a label in place of 0, and the label will update to whichever year corresponds Year Offset =0.
SanskrutiHelper II
Helper IIokay. And is it possible if we do this in dropdown?
And in the year offset column we have defined the end date. Will it dynamically change if the year changes?