Forum Discussion

Sanskruti's avatar
Sanskruti
Helper 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
OwenAuger's avatar
OwenAuger
Super User
2 years ago

Yes, 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.

Sanskruti's avatar
Sanskruti
Helper II
2 years ago

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? 

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    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.

    • Sanskruti's avatar
      Sanskruti
      Helper II
      2 years ago

      What if i selected year in dropdown slicer and used year offset in filter?

      Will this work if the date got changed?

       

      • OwenAuger's avatar
        OwenAuger
        Super User
        2 years ago

        I don't quite follow - could you clarify what you mean by that?