How to create a Reset filters button in Power BI: step by step
This tutorial shows how to create a Reset filters button in Power BI to quickly restore a page to its predefined state. A reset button improves the user experience by allowing a return to viewing data without applied filters, especially in interactive reports with many slicers.
Prerequisites
- Power BI Desktop installed
- A report with at least two slicers or filters applied
- Basic familiarity with the interface (Visualizations, Insert, Bookmarks, Selection pane)
Step 1: Prepare the page with the predefined state
Decide which state the Reset button should restore: for example, all slicers with no selection (all) or with default values. For each slicer/visual, adjust manually to that predefined state.
Step 2: Open the Bookmarks Pane and Selection Pane
On the Insert or View tab, enable the Bookmarks and Selection pane. The Bookmark will save the state of filters and the Selection helps manage which visuals are affected. Keep the report exactly in the predefined state before creating the bookmark.
Step 3: Create the 'Reset' Bookmark
With the page in the predefined state, in the Bookmarks pane click Add and rename it to "Reset". Click the three dots of the bookmark and make sure the Data option is checked — this ensures slicer and filter selections are saved. You typically leave Display and Current Page checked for a reset of just the current page.
Step 4: Create the button that calls the Bookmark
Go to Insert > Buttons > Blank (or choose a style). Customize the text/icon (e.g., "Reset filters" or a reset icon). In the button formatting pane, enable Action, set the type to Bookmark and choose the "Reset" bookmark. Set a clear tooltip (e.g., "Reset all filters on this page").
Step 5: Test and adjust behavior
Apply some filters and click the button. The report should return to the state saved in the bookmark. If a slicer is not reset, check the bookmark: is it saving Data? Are you working on the same page as the bookmark? If you want the button to reset filters across multiple pages, you need a bookmark per page or an alternative approach (see notes below).
Step 6: Advanced option — indicate when filters are active (DAX)
It's useful to show a warning if there are active filters. Simple example: create a measure that checks if a specific column is filtered and displays a text. Replace 'Tabela' and 'Coluna' with your model.
Filtros_Ativos =
IF(
ISFILTERED('Tabela'[Coluna]) || HASONEVALUE('Tabela'[Coluna]),
"Filtros activos",
"Sem filtros"
)
Place this measure in a card so the user sees if there are still active filters before clicking Reset.
Verify the result
To confirm it's correct: make selections in several slicers, click the Reset button and verify that all slicers return to the predefined state. Test with different users (if you share the .pbix file) and ensure the bookmark was not accidentally changed. Common errors: bookmark without the Data option checked, bookmark created before adjusting all visuals, or the button pointing to the wrong bookmark.
Conclusion
A Reset filters button in Power BI is a simple solution that improves report usability and gives the user quick control to return to the predefined state. Next steps: create different bookmarks for scenarios (e.g., "Product view", "Region view") or implement a reset across multiple pages using slicer synchronization and multiple bookmarks. Tip: want the reset button to also clear filters applied via interaction with visuals (cross-filter)? Always check the Data option in the bookmark and test in reading mode.