Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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!
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!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |