Date hierarchy slicer, limit how many years are shown

[KalvisT]

Hei,

I have created a date table with DAX Calendar. Im using it to filter other tables that has date columns. 

The problem is that the table I created contains many years in the future. How could I limit date hierarchy slicer so that it would show only Previous, This and Next year? Or this and previos year. 

Thanks a lot! 

[Anonymous]

Hi @KalvisT ,

How about adding a year slicer? Filter the years you want directly.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@KalvisT , You can create a new column like this and filter at page or slicer level using that

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
year([Date])= year(Today())+1,"Next Year" ,
Format([Date],"YYYY")
)

[KalvisT]

Thanks for the idea, but adding it on all page level doesn't reduce the amount year values on my date hierarchy slicer. Have added it as is this year or next year but sadly doesn't do the trick.