Using a year from date hierarchy in a slicer does not offer relative date

[gregorr]

I am using a slicer with a Year from date hierarchy and I would like to filter it for the past 3 years but it does not offer me relative date.

Date hierarchy is provided from the Date table (CALENDARAUTO()).

How to apply filter to the Year slicer that will show only the past 3 years?

[Anonymous · Accepted solution]

Hi @gregorr ,

Based on my testing, if using a slicer with a year from  date hierarchy, it is impossible to choose relative date in slicer settings.

please try the following methods:

1.Create the simple table.

2.Drag the date column into slicer visual and select relative date in slicer settings.

3.Select last three years in the slicer. The result is shown below.

You can also view the following documents to learn about relative date slicer.

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

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

[Wilson_]

Hi gregorr,

If you want to use relative date, you need to be using an actual date/datetime column. Put a filter in your slicer visual for date.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.