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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Harshi_99
New Member

How to make a Reset button for synced slicer?

I have slicers on all my tabs and all of them are synced. The problem is, if i forget on which page I used the slicer first, the reset button doesn't work to reset the filters set on other pages.

I have to go back to the page where I first used it, 'Reset' button works on that page only.

 

I want to make it so that regardless of which page we are on, the 'reset' button clears all slicer filters.

 

How can we make it work?

1 ACCEPTED SOLUTION
ftgpdx
Frequent Visitor

  1. Enable the Selection pane then group your slicers (https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-visuals).
  2. Repeat for each page.
  3. Insert a button (https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-buttons?tabs=powerbi-desktop)
  4. Repeat for each page.
  5. Enable the Bookmark pane. 
  6. From any page, select the slicer group from the Selection pane
  7. Choose to Add a new Bookmark from the Bookmark pane. 
  8. Right-click on that new bookmark and change selections so only "Data" and "Selected Visuals" have a checkmark. 
  9. Right-click the bookmark again and choose to update. 
  10. Apply that bookmark to your newly created Reset button on each page. 
  11. That's it

Now the reset button will reset all filters in that group across all pages and you can disregard the built-in reset button at the top of the Power BI menu bar. The only time I've found that option necessary is when using the cross-report feature. 

 

I've found that same 'selective reset' helpful to differenciate between calendar slicers and other groupings of slicers. 

 

Enjoy!

View solution in original post

2 REPLIES 2
ftgpdx
Frequent Visitor

  1. Enable the Selection pane then group your slicers (https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-visuals).
  2. Repeat for each page.
  3. Insert a button (https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-buttons?tabs=powerbi-desktop)
  4. Repeat for each page.
  5. Enable the Bookmark pane. 
  6. From any page, select the slicer group from the Selection pane
  7. Choose to Add a new Bookmark from the Bookmark pane. 
  8. Right-click on that new bookmark and change selections so only "Data" and "Selected Visuals" have a checkmark. 
  9. Right-click the bookmark again and choose to update. 
  10. Apply that bookmark to your newly created Reset button on each page. 
  11. That's it

Now the reset button will reset all filters in that group across all pages and you can disregard the built-in reset button at the top of the Power BI menu bar. The only time I've found that option necessary is when using the cross-report feature. 

 

I've found that same 'selective reset' helpful to differenciate between calendar slicers and other groupings of slicers. 

 

Enjoy!

amitchandak
Super User
Super User

@Harshi_99 , You should be able to reset the slicer from any page, in case of a sync slicer. Or you can explore the All pages filter on the filter pane

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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