Forum Discussion

qmestu's avatar
qmestu
Helper IV
4 years ago
Solved

Default value for date slicer

Hi,

 

I have a slicer that is currently getting its values from a generated date table and setting the value to the years in the "between" mode. Is it possible to set a default value for a subset of years? Let's say that i have 10 years in total but i would like to show the last 5 years when the user opens the dashboard.

 

Thanks.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    qmestu , You can use a visual level filter. You can use relative date filter

     

    or create a column like this and use that as filter 

     

    Switch( True() ,

    Year([Date]) >= year(Today()) -5 && Year([Date]) <= year(Today()) , "Last 5 Year",

    Year([Date])

    )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    qmestu , You can use a visual level filter. You can use relative date filter

     

    or create a column like this and use that as filter 

     

    Switch( True() ,

    Year([Date]) >= year(Today()) -5 && Year([Date]) <= year(Today()) , "Last 5 Year",

    Year([Date])

    )