Buttons as slicers

[Anonymous]

Hi,

I would like to have a button on my report that when pressed a specific matrix filters to MTD results and then when pressed a second time it undoes the MTD filter and shows all results for all dates. Also ideally the button should say "MTD" when pressing it to get MTD results and say "All" when pressed a second time to indicate the end user is now seeing all results

The first part of the above I have achieved by bookmarking a page whereby the matrix shows MTD results are shown and when pressing the button I see the MTD results. So is there a way to add a second action to this button to achieve the second part of above?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Based on my understanding,you could create 2 buttons,one is called "MTD" and another is "All",then relate them to certain bookmarks as you wish.

For details,you could refer to below vedio:

https://www.youtube.com/watch?v=0m-PCX1uCG4

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , I think the bookmark and button should able to help in this case.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

If it just a measure then measure slicer can also help

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME