How to Filter Slicer in Power BI

Power BI slicers are fantastic for giving users control over a report, but they often present a frustrating problem: they show every single option from a data column, even those that are totally irrelevant. This clutters your dashboard and can confuse your audience. This guide breaks down exactly how to filter the list of values within a slicer so you can build cleaner, more intuitive reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why You Should Filter Your Power BI Slicers

By default, when you add a slicer for a field like "Product Name," Power BI lists every product in your database. The issue arises when half of those products haven’t had a sale in three years or are related to a service line you're not analyzing in the current report. Your user is left scrolling through a long list of options, many of which will simply result in a blank chart when selected.

Filtering your slicers solves three key problems:

• Better User Experience: It prevents users from having to scroll through dozens of irrelevant options. This makes your dashboard feel tailored and professional.
• Reduced Confusion: It eliminates the dreaded "I selected something and now everything is blank" scenario. By only showing options with related data, you ensure every click leads to a meaningful view.
• A Cleaner Interface: Less clutter on the page means the user can focus on the data that matters most.

Let’s go through the most effective methods to get this done, from simple manual filtering to dynamic, measure-based approaches.

Method 1: Basic Filtering on the Slicer Visual

The simplest way to control what appears in a slicer is to use a direct visual-level filter. This is perfect when you have a static list of items you want to display or hide, and that list doesn't need to change dynamically.

Imagine you have a sales report and a slicer for continents, but your company only operates in North America and Europe. Showing South America, Asia, and Africa is just noise. Let's filter them out.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Step-by-Step Instructions:

1. Create your slicer: Start by adding a slicer visual to your Power BI canvas and drag your desired field (e.g., 'Continent') into the "Field" well. You'll see all the continents listed.
2. Select the slicer: Click on the slicer visual to make it active.
3. Open the Filters Pane: You should see the Filters pane on the right side of your window. If it's hidden, go to the "View" tab on the ribbon and check the box for "Filters."
4. Add the field to the filter well: You'll see a section in the Filters pane titled "Filters on this visual." Drag your field ('Continent') from the "Data" pane into this section.
5. Configure the filter: A new filter card will appear.

Just like that, your slicer is updated. It will now only show "North America" and "Europe," providing a much cleaner choice for your users. This method is fast and easy, but keep in mind it’s a manual process - if you start selling in Asia next month, you'll need to remember to come back and update this filter.

Method 2: Dynamically Filtering a Slicer Based on Your Data

What if you only want to show products that actually have sales? Or salespeople who have closed a deal this quarter? In these cases, a manual filter is impractical because the list of relevant items changes every time your data is refreshed. The solution is to filter the slicer using a measure.

This powerful technique tells the slicer to only display items that have associated data, like revenue, units sold, or website sessions.

Let's say you have a "Product Name" slicer but want to hide any products with zero sales in the selected period. This is the most common use case for slicer filtering.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step-by-Step Instructions:

1. Create a basic measure: First, you need a measure that calculates the value you want to test against. If you don’t already have one, create a simple sales measure. Go to the "Modeling" tab and click "New Measure." Use a formula like this:
2. Create your slicer: Add a slicer to your report and drag the 'Product Name' field into it.
3. Select the slicer and open the Filters Pane: Click on your new slicer.
4. Use your measure as the filter: In the Filters pane, under "Filters on this visual," drag your '[Total Sales]' measure into the filter well.
5. Set the filter condition:
6. Apply the filter: Click the "Apply filter" button at the bottom of the filter card.

Your slicer will now dynamically update to show only the products that have recorded sales. When your dataset refreshes and a new product makes its first sale, it will automatically appear in the slicer. This keeps your dashboards effortlessly tidy and relevant.

Method 3: Creating Smart "Cascading" Slicers

A cascading (or dependent) slicer is one where the choices in the first slicer filter the options available in a second slicer. For example, when a user selects a "Region," the "Country" slicer should update to show only the countries within that region. This is essential for guiding users through a logical filtering process.

Power BI is actually pretty good at this out of the box if your data model is set up correctly.

The "It Just Works" Method (With a Good Data Model)

If you have a well-structured data model with proper relationships, this is incredibly simple.

1. Verify your relationships: Go to the "Model view" in Power BI. Make sure you have a relationship between your tables. For instance, you might have a 'Regions' table and a 'Countries' table, connected by 'RegionID'. The relationship should filter from the "one" side (Regions) to the "many" side (Countries).
2. Add both slicers: Go back to the Report view and add a slicer for 'Region Name' and another for 'Country Name'.
3. Test it: Click on a region in the first slicer, like "Europe." You’ll notice the 'Country Name' slicer immediately reacts.

By default, Power BI will show all countries but grey out the ones not in Europe. This is functional, but not always the cleanest look. For a superior user experience, we want to completely hide the non-relevant options.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

The "Clean Cascading" Method (Using a Measure)

To make the second slicer hide irrelevant values instead of just graying them out, we can apply the same measure-based filtering trick from Method 2. This is the professional standard for building truly intuitive cascading slicers.

1. Ensure you have a measure: Make sure you have a key metric that links your data together, like our '[Total Sales]' measure from before.
2. Add a slicer for 'Region' and another for 'Salesperson'.
3. Select the second slicer: Click on the 'Salesperson' slicer visual. This is the slicer we want to become dependent on the first one.
4. Apply a measure-based filter: Just like in Method 2, drag your '[Total Sales]' measure into the "Filters on this visual" well for the 'Salesperson' slicer. Set the condition to "is not blank" and apply the filter.

Now, here's what happens: When you select a Region, say "North America," the report filters everything to that region. Because the 'Salesperson' slicer is also being filtered to only show values related to non-blank '[Total Sales]', it dynamically updates to show only salespeople who have sales transactions in North America. The other salespeople aren't grayed out - they vanish entirely, leaving a perfectly clean, dependent dropdown list.

Final Thoughts

Filtering the options within a Power BI slicer is a fundamental skill that transforms a standard report into an intuitive, professional-grade dashboard. By using visual-level filters, applying measure-based conditions, and building smart cascading slicers, you can significantly improve the user experience and prevent unnecessary confusion, guiding your users directly to the insights they need.

Ultimately, data tools are all about turning raw numbers into clear, accessible reports that anyone can understand and act on. If you ever find yourself spending too much time wrestling with data models and configuring visuals, you might enjoy how we approach things. At Graphed you can connect your sources and ask, "Show me a dashboard of sales by product and salesperson, with filters for region and country," and we'll instantly build the interactive dashboard for you, filtering and all, so you can spend less time building and more time analyzing.