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...
okay. 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?
Right now, dropdown is unfortunately not possible with this new Slicer visual. And the original Slicer has no option for displaying labels and hiding values 😞
Yes, the "Year Offset" column will dynamically change on refresh as long as it is defined in a calculated column or table relative to TODAY() (using DAX) or similarly in Power Query.
My example version was defined in a calculated table using the TODAY() function to determine the current year.