Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I am pretty new at Power BI, but I can't wrap my head around this problem:
In my date table I have these 4 columns:
These columns returns true/false values if the date is in "the last 12 months" or "last 16 weeks", etc.
The problem is this:
I want to create a slicer with "Year", "Quarter", "Week" and "Month" that shows the given period in my visuals.
Any idea on what I should do next?
When I choose "year", it should return the last 3 years.
Solved! Go to Solution.
You can use the built-in slicer for creating dynamic date ranges like "last # day" or "last # month" etc.
Follow these steps: make a slicer > Slicer settings > style: Relative Date
Thanks for solutions. But it is not exactly what I need.
It wont change the values on x axis (showing year when I filter on months).
I`ve created a Dynamic Date table:
Is there any way I can use the "Dyanamic Date" column as a slicer, and connect the "Year" row to the
"(true/false) Last 3 Years" column in date table?
Example:
If I press "Year" It should return the last three years (they have value "True" in 'Date'[(true/false) Last 3 year]).
You can use the built-in slicer for creating dynamic date ranges like "last # day" or "last # month" etc.
Follow these steps: make a slicer > Slicer settings > style: Relative Date
you can try to create a measure.
= if(selectedvalue(column)="Year" && max((true/false)Last 3 years)=true(), 1)
then add this measure to visual filter and set to 1.
Proud to be a Super User!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.