Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |