Forum Discussion

masterpbi's avatar
masterpbi
New Member
1 year ago
Solved

Create reset button in PBI

Hi everyone, As far as I know, we can create a reset button in Power BI using the default “Clear all slicers” option or by using a bookmark. My report requires having two buttons: “Apply Filter” and...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi masterpbi 

     

    Yes this is a known limitation in Power BI. Right now, there’s no built-in way to have both an "Apply Filter" and a "Reset Filter" that takes slicers back to specific values especially if the slicers haven’t been applied yet.

     

    The "Clear all slicers" button only resets everything to "All", and bookmarks won’t behave as expected unless filters are applied first which can be frustrating.

     

    What usually works is setting up two bookmarks:

    • One for your default state (with slicers pre-selected)

    • Another for the filtered state

     

    Then link them to two buttons:

    • Apply Filter - linked to the filtered view

    • Reset Filter - linked to the default view

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi masterpbi 

Yes there is limitations of both “Clear all slicers” and bookmark-based approaches in Power BI when trying to create a fully functional "Reset Filter" button that restores specific default slicer values, not just "All".

But still try the below approach: 
1. Create two slicers:

  • Slicer Set A – Default values set → This will be visible by default.
  • Slicer Set B – Slicers used by the user to make selections → This is normally hidden and shown only after clicking “Apply Filter”.


2. Create Bookmarks:

  • Bookmark 1: Default View (Reset State)
  • Show Slicer Set A
  • Hide Slicer Set B
  • Set visuals and filters as needed
  • Enable "Data" and "Display" (uncheck "Current Page" unless needed)

 

  • Bookmark 2: Applied Filters View
  • Hide Slicer Set A
  • Show Slicer Set B
  • Enable "Display" only (do not check "Data" to preserve user selections)


3. Add Buttons:

  • Apply Filter → linked to Bookmark 2
  • Reset Filter → linked to Bookmark 1

 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!