How to Filter a Visualization in Power BI

Filtering a specific chart or table in a Power BI report, without changing anything else on the page, is one of the most common tasks you'll face. It allows you to create specific, focused views - like showing one chart of 'YTD Sales' next to another showing 'Last Quarter Sales' - on the same dashboard. This guide will walk you through exactly how to apply these visual-level filters using Power BI's built-in tools.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding Power BI's Filtration Layers

Before focusing on one visual, it's helpful to understand that Power BI filters exist at different levels. Think of them as Russian nesting dolls, where each filter can affect the one inside it. When you apply a filter, it cascades down.

• Report-level filters: These are the broadest filters. Anything you apply here affects every single page and every visual in your entire report. This is great for setting a global context, like filtering out all data before a specific year.
• Page-level filters: As the name suggests, these filters apply to all the visuals on a single page. If you want a whole dashboard page dedicated to a specific country or sales region, this is the tool for the job.
• Visual-level filters: This is our focus. These ultra-specific filters apply to just one selected visual, leaving all others on the page untouched.
• Drillthrough filters: This is a more advanced type where user selections on one page dynamically filter the content of a dedicated "drillthrough" page, providing more detail on a specific data point.

When you need to tell two different stories with two charts sitting side-by-side, visual-level filters are your answer.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 1: The 'Filters on This Visual' Pane (The Direct Approach)

The simplest and most direct way to filter a single visual is by using the dedicated section in Power BI’s Filters pane. This approach is perfect when you, the report creator, want to set a permanent filter on a visual that end-users won't need to change.

Let’s say you have a bar chart showing total sales by product category, but you want this specific chart to only show sales from the "Electronics" and "Appliances" categories.

Step-by-Step Instructions

1. Select Your Visual: The first step is to click on the specific chart, table, or card you want to filter. When you select it, a border will appear around it, and the Fields and Visualizations panes will update to reflect its properties.
2. Open the Filters Pane: To the right of the Visualizations pane, you’ll find the Filters pane. If it's collapsed, just click on its header to expand it. You’ll see sections for "Filters on this visual," "Filters on this page," and "Filters for all pages."
3. Drag and Drop Your Filter Field: From the Data pane (the far-right panel showing all your tables and columns), find the field you want to filter by. In our example, this would be the ‘Product Category’ field. Click, drag, and drop this field directly into the box that says "Add data fields here" under the "Filters on this visual" section.
4. Configure Your Filter Logic: Once you drop the field inbounds, a menu will appear allowing you to define the filter. The options you see will depend on the data type of the field (text, number, or date).

Filtering Text & Category Data

Continuing our example, since 'Product Category' is a text field, you'll see a list of all available categories.

• Basic filtering: This is the default. You can simply check the boxes next to the values you want to include. We'd check "Electronics" and "Appliances." The visual will instantly update.
• Advanced filtering: If you need more specific logic, click the "Filter type" dropdown and choose "Advanced filtering." This lets you set rules like "Show items when value contains 'Elec'" or "Does not start with 'Clothing'."

Filtering Numeric Data

If you dragged a numeric field like 'Sales Amount' into the filter box, your options would be different. Let’s say you want a visual to only show sales transactions over $1,000.

• Advanced filtering: Here, you'd set rules like "Show items when value is greater than 1000" or you can filter for values that are "less than," "is not," or "is blank."
• Range filtering: For a more intuitive slider, choose "Top N" to show the Top 5 products by sales, or "Between" to filter for sales that fall between, for example, $500 and $1,500.

Filtering Date Data

Date fields offer powerful, dynamic filtering options. If you want one chart to always show data from 'This Year', you can.

• Relative date filtering: This is incredibly useful. You can set dynamic filters like "Show items when value is in the last 30 days," "in this quarter," or "in the next 2 months." The chart will automatically update as time passes.
• Range filtering: A calendar or slider will appear letting you choose a fixed date range, such as from January 1, 2023 to December 31, 2023.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Hiding or Locking a Filter

Once your filter is set, you have two final options, visible by hovering over the filter in the Filters pane:

• Lock filter: Click the padlock icon to prevent end-users from changing this filter in the published report.
• Hide filter: Click the eye icon to hide the filter from view in the final report. This is great for cleaning up the user interface. You can lock and hide a filter to bake its logic into a visual without cluttering the Filters Pane for your viewers.

Method 2: Using Slicers and 'Edit Interactions' (The Interactive Approach)

Sometimes, you don't want a fixed filter. Instead, you want to give the user an interactive control - like a button or a dropdown - to filter one specific visual themselves. This is where slicers come in, combined with a feature called "Edit Interactions."

A slicer is just a special type of visual that acts as an on-page filter. By default, a slicer filters everything else on the page. But you can easily change that.

Step-by-Step Instructions

1. Add a Slicer to Your Report Page: First, make sure no visuals are selected by clicking on an empty area of your report canvas. Then, in the Visualizations pane, click the Slicer icon (it looks like a funnel with a list). A blank slicer will appear on your page.
2. Add a Field to the Slicer: With the new slicer selected, drag the field you want to use as a filter into its 'Field' well. For example, drag 'Year' into the slicer to create a control that lets users choose a specific year.
3. Enable 'Edit Interactions': This is the most important step. Select the Slicer you just created. Then, go to the Format tab on the Power BI ribbon at the very top of the window. In the 'Interactions' section, click the 'Edit interactions' button.
4. Define the Slicer's Behavior: Once you click 'Edit interactions', you'll see small icons appear at the top-right corner of all the other visuals on the page. These icons control how the selected slicer affects them. You'll typically see two options: a filter icon and a "none" icon (a circle with a diagonal line).
5. Turn Off Filtering for Most Visuals: For every visual on the page that you do not want this slicer to affect, click the 'None' icon. This 'breaks' the connection between that slicer and the visual.
6. Turn On Filtering for Your Target Visual: For the one visual you do want the slicer to control, make sure its 'Filter' icon is selected. This is usually the default setting, so you might not have to change anything here.
7. Turn Off 'Edit Interactions': Once you've configured the interaction for each visual, click the 'Edit interactions' button in the Format ribbon again to turn the mode off. The small icons will disappear.

And that’s it! Now, when a user makes a selection in that slicer, only the specific visual you linked it to will update. All the others will remain static. This method gives you the power to build highly targeted and interactive dashboards.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Final Thoughts

Successfully filtering a single visual in Power BI boils down to choosing the right tool for the job. Use the 'Filters on this visual' pane for static, behind-the-scenes filtering dictated by you, the creator. When you want to hand control to your audience, use a slicer combined with 'Edit Interactions' to provide a focused, interactive experience.

Building reports like this in tools like Power BI is a powerful skill, but the learning curve can be steep to master all the granular configurations. We built Graphed because we believe getting insights shouldn't require dozens of configuration clicks. Instead of moving slicers and editing interactions, you can simply connect your data sources - like Google Analytics, Shopify, or Salesforce - and ask for what you need in plain English. For example, tell us "Show me last quarter's sales in the UK as a bar chart" and the visual is built for you, in seconds, without ever opening an interactions pane.