Forum Discussion
Buttons as slicers
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?
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,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
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=vlnx7QUVYMEHi 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,
KellyDid I answer your question? Mark my post as a solution!
