Forum Discussion

Harshi_99's avatar
Harshi_99
New Member
3 years ago
Solved

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 ...
  • ftgpdx's avatar
    3 years ago
    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!