Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I currently have a group of slicers showing and the visuals are showing comments left by team members on a survey. I added a button to show the last 7 days for the selections made in the slicers, but now I'd like to have a "show all" button where it would show you all data for the selections made within the slicers. I have a clear all filters button but that's not going to work because it will clear all selections made in the slicers. How could I achieve this?
Hi, @jcastr02
Based on my research, there is no direct way to achieve your requirement. I'd like to suggest you use bookmarks as a workaround. You may create two bookmarks. One displays the page of 'clear all' and another displays the page of 'show all' with a button linked to them. For further information, please refer to the following link.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-alq-msft thank you! I currently have a bookmark to clear all selections, and one bookmark to show last 7 days, let's say that I went and selected a few of the slicers, then click show last 7 days, now I want to "show all" (for the selections made on the slicers) I wouldn't want to click clear all because then I would have to reselect everyting in the slicers...any other thoughts, a bookmark would not work because it would depend on what the end user selected...
Refer if these can help
https://community.powerbi.com/t5/Desktop/Reset-all-filters/td-p/459996
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
@amitchandak Thank you, I am currently using a bookmark to clear all slicers. I am interested in if someone choose two or three slicers, then they click show last 7 days (which I have), now they want to click show all, they shouldn't click clear slicers because I don't want them to have to reslect their options they picked,
Goal would be to have 3 buttons - Clear all slicers, Show last 7 days, and show "all" (with the current selection)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
76 | |
61 | |
36 | |
32 |
User | Count |
---|---|
91 | |
60 | |
59 | |
49 | |
45 |