Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Show Applied Filters in Power BI

Cody Schneider••7 min read

Ever published a Power BI report only to get an email asking, "Am I looking at data for all regions or just the West?" Making your reports interactive with slicers is great, but if users can't easily see which filters are active, they lose confidence in the data. This article will show you exactly how to display applied filters directly on your report canvas, making your dashboards more transparent and user-friendly.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

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

Watch Graphed demo video

Why Bother Showing Applied Filters?

In Power BI, the Filters pane is certainly useful during development, but it's often collapsed by default for end-users. Relying on it is like hiding a key piece of context off-screen. When users can't instantly see the scope of the data they're viewing, a few problems arise:

  • Misinterpretation: A user might think they're looking at total company performance when, in fact, a filter for a specific product line is active from their last session.
  • Lack of Trust: If the numbers look "wrong" because of an unseen filter, users start questioning the report's accuracy.
  • Poor User Experience: It's simply not intuitive. Forcing users to hunt for applied filters adds unnecessary friction to their analysis.

By making filters visible, you provide immediate context, eliminate confusion, and build trust in your reports. Let’s walk through the most effective ways to do this using DAX and visuals.

Method 1: Displaying a Single Slicer Selection with a Card Visual

The most common scenario is wanting to show the current selection from a slicer that only allows one choice at a time (like a dropdown or a single-select list). This is perfect for filters like a chosen sales region, a specific year, or a product category.

The key here is the SELECTEDVALUE DAX function. It checks if a single value is selected in a specified column and returns that value. If no value or multiple values are selected, it returns a blank or an alternate text you provide.

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.

Step-by-Step Instructions:

  1. Add a Slicer: First, ensure you have a slicer on your report page. For our example, let's use a "Product Category" slicer from a sales data table.
  2. Turn on "Single Select": For this technique to work best, select the slicer, go to the "Format visual" pane > "Slicer settings" > "Selection," and turn on "Single select."
  3. Create a New Measure: Right-click on your data table in the Data pane and select "New measure." This will open the formula bar.
  4. Write the DAX Formula: Enter the following formula. This measure will capture the selected category or show "All Categories" if nothing is selected.
Selected Category = SELECTEDVALUE('Sales'[Product Category], "All Categories")

Breaking Down the Formula:

  • Selected Category = is the name of our new measure.
  • SELECTEDVALUE(...) is the function we're using.
  • 'Sales'[Product Category] is the column that our slicer is based on. Always use the format 'TableName'[ColumnName].
  • "All Categories" is the optional alternate text that will be displayed if no single category is selected. This is crucial for handling the "all data" view gracefully.
  1. Use a Card Visual: Go to the Visualizations pane and add a Card visual to your report canvas.
  2. Assign the Measure to the Card: Drag your new [Selected Category] measure into the "Fields" area of the Card visual.

Now, when you select "Electronics" in your slicer, the card will display "Electronics." If you clear the slicer selection, the card will obediently show "All Categories". You've just created a dynamic title that updates with user interaction!

Method 2: Displaying Multiple Slicer Selections

What if you want users to select multiple items from a slicer? For example, they might want to see data for Electronics, Home Goods, and Clothing. In this case, SELECTEDVALUE won't work because it returns a blank when more than one value is selected.

Here, our tool of choice is the CONCATENATEX DAX function. It iterates over a table (in this case, the selected values from our slicer) and joins them together into a single text string, separated by a delimiter of your choice.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

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

Watch Graphed demo video

Step-by-Step Instructions:

  1. Make a Slicer Multi-Select: If you're following from the last section, turn off the "Single-select" option in your "Product Category" slicer settings.
  2. Create a New Measure: Right-click your table, choose "New measure," and get ready for a slightly more advanced formula.
  3. Write the DAX Formula:
Selected Categories List = 
VAR NumOfCategories = DISTINCTCOUNT('Sales'[Product Category])
VAR SelectedCats = COUNTROWS(VALUES('Sales'[Product Category]))

RETURN
IF(
    SelectedCats = NumOfCategories, 
    "All Categories", 
    CONCATENATEX(
        VALUES('Sales'[Product Category]), 
        'Sales'[Product Category], 
        ", "
    )
)

Breaking Down the Formula:

This formula is a bit more robust and user-friendly:

  • VAR NumOfCategories: This variable counts all unique categories available in your entire dataset.
  • VAR SelectedCats: This variable counts only the categories currently selected in the slicer context.
  • RETURN IF(...): This is the logic check. We say: "If the number of selected categories is the same as the total number of categories available, then display the text 'All Categories'." This happens when nothing at all is selected in the slicer (as 'all' are considered selected) or if the user manually selects every single one.
  • "All Categories": This is the text displayed if the "IF" condition is true.
  • CONCATENATEX(...): If the IF condition is false (meaning a subset of categories is selected), this function runs.
  1. Use a Card Visual: Just like before, drag this new [Selected Categories List] measure onto a Card visual.

Now, your card will adeptly display "All Categories" with no selections, list out multiple comma-separated selections like "Electronics, Accessories," and show a single value when just one is picked. Pretty neat!

Method 3: Creating a Comprehensive Filter Summary Title

Displaying selections for one slicer is helpful, but a truly great report offers an "Air Traffic Controller"-like summary for readers showing all key filters at once in a readable, intuitive way. You can easily achieve this by combining your filter measures from before inside another measure to get the exact view you love most.

Think of it as simply building some Lego creations with individual "LEGO block Measures"! Imagine you have one slicer for Region and another for Product Category.

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.

Step-by-Step Instructions:

  1. Create Individual "Filter Picker" Measures: First, create a separate measure for each slicer using the SELECTEDVALUE or CONCATENATEX methods we already covered.
Selected Region = SELECTEDVALUE('Sales'[Region], "All Regions")
Selected Product = SELECTEDVALUE(Products[ProductName], "All Products")
  1. Create the "Master Summary" DAX Measure: Create one more "Master" measure where we concatenate them all together. Here we will format them to taste and add some introductory text along an elegant '| ' separator! You can use regular ampersands (&) symbols or the CONCATENATE() DAX function — they both achieve the same end-result.
Report Filter Summary = "Currently Viewing --  Region: " & [Selected Region] & "   |  Product:  " &  [Selected Product]
  1. Use a Visual to Display: Once again now, it's just as simple as adding this 'top-level' measure to one single "Card visual"! You can format it and align it at the very top for your Power BI dashboards and reports to now create an awesome, self-updating "sub-title" showing the exact 'lay of the land' of everything being shown for your stakeholders!

This master summary technique is fantastic for report headers. Now with a quick glance at the very top of each page, stakeholders can instantly tell what's what to provide an unparalleled dashboard experience for them! It centrally locates all the main filters, providing immediate context as soon as they open the report.

Final Thoughts

Making applied filters visible is a small effort that pays big dividends in report usability and user trust. By using DAX functions like SELECTEDVALUE and CONCATENATEX with Card visuals, you can move essential context out of the hidden Filters pane and put it right where your users can see it, transforming a good report into a great one.

While mastering DAX can give you precise control, sometimes you just need to get quick answers without writing formulas. We built Graphed for those moments. You can securely connect your data and then ask questions in plain English, like "show me sales for Electronics and Accessories in the West region last quarter." Graphed understands your intent, filters the data automatically, and builds a live dashboard in seconds, saving you from having to manually configure every element.

Related Articles