Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
jcastr02
Post Prodigy
Post Prodigy

Show all button

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?show all.png

4 REPLIES 4
v-alq-msft
Community Support
Community Support

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...

amitchandak
Super User
Super User

Refer if these can help

https://community.powerbi.com/t5/Desktop/Clear-All-Slicers-by-one-button-in-power-bi-desktop/td-p/49...

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.