To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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.