Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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!
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |