Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Stefson
Regular Visitor

Using buttons to filter by last x month for the entire Dashboard

I have buttons to change the date "type" on every visual on dashboard, like switching from "monthly view" to "daily view" using parameters as filters. But fot that I need to set the parameter I created as the X axle or something like that. 
I want to create buttons to set the entire Dashboard to be quickly filter by "last 6 months" or "last 3 months" just by clicking in one button at the screen. I mean, it won't be any necessary to type something or some number then press enter. 
Currently I can set "relative filter" on the side filter display, but I would like to make it into a button on main screen. Is it possible?
Bookmarks won't help considering the amount of bookmarks I already have.

1 REPLY 1
Stefson
Regular Visitor

I found a solution, but I don't know if this is the best.
I have a "Last Months" metric where I number the months in descending order, starting from 0 (current month) to the oldest month in my calendar dimension.
I then created a second table "Last N Month" Relating 'Last N Month'[Month Number] to 'Calendar'[Last Months]
With this configuration I can now use the 'Last N month'[Number of month] filter as buttons to get the expected result.
Example2.pngExample.png

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors