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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

How to reset slicers on multiple sheets/tabs

Hello,

 

  I want to create a master reset button that will reset all of the slicers in my report. I have multiple report pages and each page has two slicers. I created a bookmark called Home/Reset and I can reset the slicers on the first page, but I do not know how to include the slicers on the other pages. What ideas do you have?

 

Cheers,

 

Peter

1 ACCEPTED SOLUTION
patBear
Helper I
Helper I

@Anonymous What if you have all of the slicers on your first page, just hide the ones you don't want to actually show on that page.  If you sync these first-page sliders with the other pages, then resetting them on the first page would reset them on the other pages too.  I haven't actually tried this, but it seems like it would work.  Good luck.

 

View solution in original post

5 REPLIES 5
patBear
Helper I
Helper I

@Anonymous Did you ever get this figured out?  I've been fiddling with bookmarks, and it seems you can create a bookmark, right click on it, and turn off "Current page" if you want slicers on other pages to be impacted by the bookmark settings.  Of course, you can then create a button whose action is this bookmark.

Anonymous
Not applicable

Is there any other way than having invisible synched slicers?

I don't know of any because bookmarks seem specific to a single page.

Anonymous
Not applicable

Thanks for the reply. I would need to have about 16 invisible slicers on my first page. Is there some other way, perhaps a way to select the slicers on the different pages?

 

Cheers!

patBear
Helper I
Helper I

@Anonymous What if you have all of the slicers on your first page, just hide the ones you don't want to actually show on that page.  If you sync these first-page sliders with the other pages, then resetting them on the first page would reset them on the other pages too.  I haven't actually tried this, but it seems like it would work.  Good luck.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.