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?