How to Deselect in Power BI
Navigating a Power BI report can feel like magic when you first see your visuals interact, but that magic can quickly become frustrating when you can't figure out a simple action: how to deselect something. You click a bar on a chart to get a closer look, and suddenly your whole report is filtered. Now, how do you get back to the default view? This article demystifies the process by showing you several ways to deselect in Power BI, from the simple click to building your own reset button.
Why Deselecting Is So Important (And Sometimes Confusing)
In Power BI, nearly every visual element can act as a filter for other visuals on the page. This "cross-filtering" is one of its most powerful features. When you click a data point - like a country on a map, a specific product in a list, or a date on a timeline - Power BI automatically highlights related data in other charts.
But this is a two-way street. Once you've drilled down into a specific segment, you need an easy way to zoom back out. Getting "stuck" in a filtered view can hinder your analysis and make presenting your findings confusing. Whether you’re exploring data on your own or building a dashboard for colleagues, knowing how to quickly clear selections and reset the view is a fundamental skill. Let's cover the easiest methods first and work our way up to more advanced, user-friendly solutions.
Method 1: The Simple Click in Whitespace
This is the quickest and most common way to deselect a single item in Power BI. If you’ve clicked on a data point and filtered your report, all you need to do is click on an empty area of the report canvas.
Imagine you have a sales dashboard with a bar chart showing revenue by product category. You click on the "Electronics" bar, and all the other visuals update to show data only for electronics. To see the report for all product categories again, simply click in the blank space next to or around any of your charts. The report will instantly snap back to its unfiltered, default state.
Step-by-Step:
- Click a data point in any visual (e.g., a slice of a pie chart, a bar in a column chart).
- Observe how the other visuals on the report page update to reflect your selection.
- Move your cursor to any blank area on the report canvas where there are no visuals.
- Click once. All selections will be cleared, and your report will return to its original state.
When this doesn't work: This method is fantastic for quick analysis, but it has a key limitation. On very dense or packed dashboards, there might not be any available "whitespace" to click. Clicking on another visual will simply select that new visual instead of clearing the old selection. In these cases, you’ll need another method.
Method 2: Use "Ctrl + Click" to Toggle Selections
The Ctrl + Click shortcut is a versatile tool in Power BI for managing selections. While it's most often used to select multiple items at once, it also works as a toggle to deselect individual items.
If you have a single item selected, holding the Ctrl key and clicking that same item again will deselect it, effectively clearing your filter.
Example Scenario: Fine-Tuning Your View
Let's say you're analyzing regional sales and you want to compare North America and Europe.
- First, click on "North America" in your sales map. The report filters.
- Next, hold down the Ctrl key and click on "Europe". Now, your report shows the combined data for both regions.
- After reviewing, you decide you only want to see Europe. Simply hold Ctrl and click on "North America" again. This deselects North America, leaving only Europe filtered.
- To clear all selections, you can then
Ctrl + Clickon "Europe", or just click in some whitespace.
This method gives you precise control over which data points are included in your filter, making it great for comparative analysis.
Method 3: Leverage Slicers for Obvious Control
While the first two methods are perfect for report creators, they aren’t always intuitive for end-users who might not be familiar with Power BI's quirks. The most user-friendly way to handle filtering and deselection is with slicers.
A slicer is a visual that only exists to filter other visuals. Critically, slicers often come with a built-in “Clear selections” button, which is usually represented by a small eraser icon in the slicer's header. This gives your users a clear, unambiguous button to click to reset their view.
How to Add a "Clear selections" Option to a Slicer
When you add a slicer to your report, Power BI gives you options to customize its controls.
Step-by-Step Instructions:
- Click the Slicer icon in the Visualizations pane and add a field to it (e.g., 'Product Category').
- With the slicer selected, go to the Format visual pane (the paintbrush icon).
- Expand the Slicer settings section. In some newer versions of Power BI, this is found under Slicer header. Look for an option that says Show "Clear selection" or a similar toggle. Make sure this is turned on.
- An eraser icon will now appear in the top-right corner of your slicer. Click it once, and it will deselect all items within that specific slicer.
Using slicers for your primary filters makes your dashboard much more approachable. Your teammates don't have to guess how to reset the view, they see a button that has a clear purpose.
Method 4: Create a Dedicated "Clear All Filters" Bookmark Button
This is a pro-level technique to create the ultimate user-friendly experience. Instead of just clearing a single slicer, you can create one master button that resets every single filter and slicer on the entire report page, returning it to its "as published" state. You achieve this with bookmarks.
A bookmark in Power BI saves the current state of a report page - including all active filters and selections.
Step-by-Step Guide to Creating a Reset Button
This process has two parts: creating the bookmark for the reset state, and then linking a button to that bookmark.
Part 1: Create the Bookmark
- First, prepare your report page. Clear all existing selections using one of the methods above so the report is in its clean, default view.
- Go to the View tab in the Power BI ribbon and check the box for Bookmarks to open the Bookmarks pane.
- In the Bookmarks pane, click the Add button. This creates a new bookmark of your current (unfiltered) view.
- Double-click the new bookmark to rename it something descriptive, like
Reset VieworClear All Filters. - This is the most important step: click the ellipsis (...) next to your new bookmark and make sure the Data option is checked. Uncheck Display and Current Page. This tells the bookmark to only reset the data filters, without affecting things like visual visibility which can cause unexpected behavior.
Part 2: Link the Bookmark to a Button
- Go to the Insert tab in the ribbon.
- Click on Buttons and choose a button shape. The Blank option is often the most flexible.
- Place and resize the button on your report canvas where it makes sense (e.g., near the top corner).
- With the button selected, go to the Format pane.
- Under Button > Style (or Shape > Text in newer versions), add text to your button, such as "Reset Filters". Style it to match your report's design.
- Turn on the Action toggle.
- Expand the Action settings. Set the Type to Bookmark.
- In the Bookmark dropdown, select the
Reset Viewbookmark you created earlier.
That's it! Now, clicking on that button will instantly reset everything on the page. In Power BI Desktop, you'll need to hold Ctrl while clicking to activate the button, but in the Power BI Service (the web version your audience will see), a single click is all it takes.
Final Thoughts
Knowing how to deselect and reset filters in Power BI is a small but critical skill for both report creators and users. You can rely on a quick click in the whitespace for your personal analysis, use slicer controls for clarity, or build a custom reset button with bookmarks for the most polished, professional dashboards that anyone can use with confidence.
If you find that learning the nuances of interfaces like Power BI takes time away from getting answers, you might appreciate a different approach. At Graphed, we’ve built an AI data analyst that lets you bypass the complex menus and step-by-step processes. Instead of manually creating buttons or remembering shortcuts, you can simply ask for what you want in plain English. We connect to your data sources and allow you to create live dashboards and get instant insights, turning hours of interface tweaks into a 30-second conversation.
Related Articles
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.