How to Create a Reset Button in Power BI
Ever create an interactive Power BI dashboard, only to find it messy and confusing after a user has clicked through a dozen different filters? To fix this, you need a simple way to get back to the report’s original state. This guide will walk you through exactly how to create a "Reset Filters" button so you can build cleaner, more user-friendly Power BI reports.
Why a "Reset Filters" Button is a Game-Changer
While it may seem like a small addition, a reset button dramatically improves the usability of any Power BI report. It’s a simple feature that empowers users and removes a common source of frustration. Here’s why it’s worth adding:
- Better User Experience: Instead of manually clearing every slicer and filter one by one, users can restore the default view with a single click. This makes exploring the data feel much less intimidating.
- Encourages Exploration: When users know they can't "break" the report or get lost in a sea of filters, they are more likely to interact with the data slicers and charts freely, leading to deeper insights.
- Provides a Clear Starting Point: Your report is designed to tell a story or present key metrics from a specific point of view. The reset button ensures that every user can easily return to that intended starting point, no matter where their analysis takes them.
- Reduces Support Questions: You’ll spend less time answering questions like, "How do I get the report back to how it was?" A clear button lets users help themselves.
The Core Concept: Power BI Bookmarks
The entire function of a "Reset Filters" button relies on one powerful Power BI feature: Bookmarks. If you've never used them before, the concept is simple. A bookmark captures a specific state of a report page and saves it for a later time.
Think of it like taking a snapshot of your report. This snapshot can save:
- The current filters and slicers.
- The visibility of visuals (which charts are hidden or shown).
- The sort order of tables and visuals.
- The focus or drill-down mode of a specific chart.
For our reset button, we will create a bookmark that captures the report in its pristine, default state. Then, we’ll create a button that tells Power BI to return to that saved snapshot whenever it's clicked. It's a surprisingly straightforward process.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Step-by-Step: Building Your First Reset Button
Ready to build it? Follow these steps, and you’ll have a professional, functional reset button in minutes.
Step 1: Set Up Your Default State
Before you can save a bookmark, you need to prepare your report page. This means setting it up exactly as you want it to appear when a user first opens it or clicks "Reset."
Go through your report page and manually clear all filters:
- Slicers: For each slicer, click the small "Clear selections" icon (it often looks like an eraser) in its top-right corner.
- Filters Pane: Open the Filters pane and clear any filters you don’t want applied by default.
- Chart Selections: Make sure no specific data points are selected within your visuals. Just click on a blank part of the report canvas to deselect everything.
Your report page should now look clean and be back to its original state.
Step 2: Create the Bookmark
Now that your report is in its default state, it’s time to take that snapshot using a bookmark.
- Navigate to the View tab in Power BI's top ribbon.
- Click on Bookmarks to open the Bookmarks pane on the right side of your screen.
- With your report in its desired default state, click the Add button within the Bookmarks pane.
- Power BI will create "Bookmark 1." It's best practice to rename it to something meaningful. Double-click the name and change it to something like "Reset All Filters" or "Default View."
You’ve now successfully saved your report’s default view!
Step 3: Configure Your Bookmark Settings (This Part Matters!)
This is the most important step for getting your button to work correctly. By default, a bookmark captures everything - filters, visual changes, and more. For a simple reset button, we only want it to apply the filter settings.
- In the Bookmarks pane, hover over your newly created bookmark and click the three dots
(…)for more options. - Look at the options under "Data," "Display,", and "Current Page." Here's how to configure them for a standard reset button:
- Finally, under the "Update all" behavior, choose "All visuals." This applies the bookmark to every visual on the page.
By unticking "Display," you've created a more robust button that only resets the data being shown, giving you more flexibility in your reports.
Step 4: Insert the Button Graphic
Now you need a clickable element for the user.
- Go to the Insert tab in the ribbon.
- Click Buttons and choose from one of the pre-built options (like "Reset") or simply select Blank for a custom design. You can also insert an Image if you have a custom icon you prefer to use. A blank button is often the most flexible.
- Position the button somewhere intuitive, like the top-right corner of your report, where users naturally expect to find utility icons.
Step 5: Connect the Button to the Bookmark
This is where you make the button functional. You need to assign an "Action" to it.
- Select the button you just added.
- With the button selected, go to the Format pane.
- Find the Action section and toggle it to On.
- Expand the Action section. From the Type dropdown, select Bookmark.
- From the Bookmark dropdown that appears, select the bookmark you created earlier (e.g., "Reset All Filters").
- (Optional) In the Tooltip text box, you can add a helpful message like "Click to clear all filters on this page." This text will appear when a user hovers over the button.
To give your button some context, you can also add text directly on it. In the same Format pane, find the Text section, toggle it to On, and type "Reset Filters." You can format the font size, color, and alignment here as well.
Step 6: Test It!
Your reset button is now ready to go. To test it in Power BI Desktop, you need to hold the Ctrl key while clicking the button.
Go ahead and apply a few random filters in your slicers. Now, hold Ctrl and click your new "Reset Filters" button. Everything should instantly return to the default view you saved in your bookmark. Once you publish the report to the Power BI service online, your users will be able to click the button normally without holding the Ctrl key.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Advanced User Tip: Creating a "Clear Selections" Button
Want a button that only clears slicers without affecting other filters you have set in the background? The process is very similar!
Set your report page to your default view just like before. Now, hold Ctrl and select ONLY the slicer visuals you want your button to clear.
When you create the bookmark, click the three dots (…) and choose "Selected visuals" instead of "All visuals." Then, finish the rest of the steps as outlined above. This powerful feature gives you granular control over exactly what gets reset, allowing for truly advanced interactive dashboards.
Final Thoughts
That's all it takes to add a powerful and user-friendly reset button to your Power BI reports. By mastering the simple bookmark feature and linking it to a button, you can dramatically improve the dashboards you build, making them cleaner, more intuitive, and far more enjoyable for anyone to use.
While mastering features like a reset button in Power BI is a great skill, we know the learning curve for these tools can be steep, especially when you need to answer a business question quickly. At Graphed you can streamline this whole process by letting you create dashboards and get insights simply by asking questions in plain English. There’s no complex setup or bookmark management, just connect your data (like Shopify, HubSpot, or Google Analytics) and ask, "show me website sessions versus sales by channel this month," and your dashboard is built for you instantly.
Related Articles
Facebook Ads for Insurance Agents: The Complete 2026 Strategy Guide
Learn how to use Facebook ads to generate quality leads for your insurance agency in 2026. This comprehensive guide covers targeting, creative strategies, and compliance rules.
Facebook Ads for Real Estate Agents: The Complete 2026 Strategy Guide
Master Facebook ads for real estate agents in 2026. Learn targeting, ad formats, budgets, and creative best practices to generate more leads.
Facebook Ads for Movers: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for movers that actually generate booked jobs—not just clicks. Budget, targeting, funnel strategy, and creative that converts.