Default value for date slicer

[qmestu]

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.

[amitchandak · Accepted solution]

@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])

)