Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Select Multiple Fields in Slicer in Power BI

Cody Schneider••8 min read

Power BI slicers are an incredibly intuitive way to filter your interactive reports, but you’ve probably run into a common roadblock: trying to filter by multiple, separate fields within a single slicer. You drag in a second field, and Power BI just replaces the first one. This article will show you exactly how to get around this limitation using a few clever and effective techniques.

GraphedGraphed

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.

Watch Graphed demo video

What is a Power BI Slicer and Why Use It?

First, a quick refresher. A slicer is simply a type of on-canvas visual filter in Power BI. Instead of using the Filters pane, slicers let you and your end-users click buttons, use sliders, or select from a list directly on the report page to filter the other visuals. They make reports feel more like interactive dashboards or applications.

Their strength lies in simplicity. Slicers are most often used for common filtering needs like:

  • Filtering a sales report by date range.
  • Selecting a specific sales region from a dropdown list.
  • Choosing a product category to see its performance.

By default, slicers perform a single select (clicking one option deselects the others). You can easily enable multi-select with Ctrl+click or by changing a setting in the Format pane, which adds checkboxes. But this multi-select functionality only applies to the values within a single field, like selecting "North America" and "Europe" from a 'Region' field. The real challenge arises when you want to put both 'Region' and 'Product Category' into the same slicer.

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.

The Big Challenge: Slicers Natively Handle Only One Field

The core reason you can't just drag two different data fields (like 'Region' and 'Sales Rep') into the slicer's "Field" well is due to Power BI’s design. A slicer visual is built to filter the data model based on the distinct values of a single column. It presents a list from that one column and uses your selection to filter your report.

When you try to add a second distinct field, Power BI interprets it as a replacement for the first one. But don't worry, there are several powerful workarounds to achieve the kind of consolidated filtering you're looking for.

Method 1: Create a Slicer Hierarchy (The "Official" Workaround)

The most common and built-in way to add multiple fields to a slicer is by first creating a hierarchy. This method is perfect when your fields have a natural parent-child relationship, such as Continent > Country > City or Product Category > Subcategory.

A hierarchy combines these related columns into a single, expandable field grouping that a slicer can use.

Step-by-Step: Creating a Hierarchy Slicer

Let's say you have sales data and you want to filter first by Region and then by Product Category within that region.

  1. Establish the Hierarchy: In the Data pane on the right side of the Power BI Desktop window, find the fields you want to combine. Click and drag the field you want as the child (e.g., 'Product Category') and drop it directly on top of the field you want as the parent (e.g., 'Region').
  2. A Hierarchy is Formed: Power BI will automatically create a new hierarchy, which might be named 'Region Hierarchy'. You'll see an icon and an expandable list containing both 'Region' and underneath it, 'Product Category'. You can rename the hierarchy if you'd like by right-clicking on it.
  3. Add the Hierarchy to a Slicer: Go to your report canvas and add a new Slicer visual. Now, instead of dragging individual fields, drag the entire 'Region Hierarchy' you just created into the 'Field' well of the slicer.
  4. Use Your New Hierarchical Slicer: At first, the slicer will only show the top-level items (the regions). You will see a small arrow next to each item. Clicking this arrow will expand the item to show the child-level items (the product categories within that region), allowing for granular selection.

This approach gives you a clean, organized slicer where users can filter broadly (just the region) or specifically (a specific category within a region).

GraphedGraphed

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.

Watch Graphed demo video

Method 2: Combine Fields into a New Column with DAX

What if your fields don't have a natural parent-child relationship? For instance, what if you want to filter by 'Sales Rep' and 'Product Category' in the same list? Creating a hierarchy here doesn't make much logical sense. In this case, your best bet is to use DAX (Data Analysis Expressions) to create a new calculated column that concatenates the two fields together.

Step-by-Step: Creating a Concatenated Slicer

Our goal is to create a new column where each row value is a combination of two other columns, such as "Jane Smith - Bikes" or "John Doe - Accessories".

  1. Navigate to the Data View: In Power BI Desktop, click on the 'Data' icon on the left-hand navigation pane to see your data tables.
  2. Select Your Table: Choose the table that contains the columns you want to combine (e.g., your 'Sales' table).
  3. Create a New Column: From the 'Column tools' tab that appears in the top ribbon, click on 'New column'.
  4. Write the DAX Formula: In the formula bar that appears, you'll enter a DAX formula to combine your two text fields. The & operator is used to concatenate (join) text. Let's combine Sales Rep and Product Category.
Rep & Category Slicer = Sales[Sales Rep] & " - " & Sales[Product Category]

Breaking down the formula:

  • Rep & Category Slicer = : This is the name for our new column.
  • Sales[Sales Rep]: This references the 'Sales Rep' column from the 'Sales' table.
  • & " - " &: This joins the first column with a separator. Using a separator like a hyphen makes the combined text much more readable in the slicer.
  • Sales[Product Category]: This references the 'Product Category' column.

Press Enter, and Power BI will generate this new column in your data model.

  1. Use a Slicer on the New Column: Go back to your 'Report' view. Add a new slicer and drag your new 'Rep & Category Slicer' column into the 'Field' well. Your slicer will now be populated with the combined values, allowing you to select specific combinations like "Jane Smith - Bikes".

Method 3: Explore Custom Visuals from AppSource

If the native hierarchy and DAX solutions don't offer the flexibility you need, a third option is to explore the world of custom visuals in Power BI's AppSource marketplace.

Power BI allows developers to create and share their own visuals, many of which are designed to overcome limitations of the standard visuals. There are several advanced slicer options available that might better suit your needs.

How to Find and Use Custom Slicers

  1. In the Visualizations pane, click on the three dots (...) at the bottom and select 'Get more visuals'.
  2. This will open the AppSource window. Use the search bar to look for terms like "hierarchy slicer", "filter", or "chiclet slicer".
  3. Browse the results to find a visual that offers the multi-field functionality you're looking for. Read the descriptions and reviews to see if it fits your use case. Popular options often provide tree-like or tabbed interfaces for managing multiple layers of filters.
  4. Click 'Add' to import the custom visual into your Power BI report. It will then appear in your Visualizations pane, ready to be used.

Note: Be mindful when using custom visuals. While many are vetted by Microsoft, they may require licensing for premium features, could impact report performance, and might have their own unique set of formatting options to learn.

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.

Best Practices for Selecting Multiple Fields

Whichever method you choose, keep these tips in mind to ensure your reports remain user-friendly and performant.

  • Use Hierarchies for Logical Relationships: Stick with the hierarchy method when your data is naturally structured, such as geographic data (Country/State) or product catalogs (Category/Subcategory). It’s intuitive for users.
  • Keep DAX Formulations Readable: Always include a separator like " - " or " | " when concatenating columns. A slicer filled with values like "AccessoriesJohnDoe" is messy and confusing.
  • Beware of High Cardinality: "Cardinality" refers to the number of unique values in a column. If you concatenate two columns that each have thousands of distinct values, your new calculated column could have millions of unique combinations. This can significantly slow down your report's performance. This technique is best for columns with a manageable number of options.
  • Clearly Title Your Slicers: Whether using a hierarchy or a DAX column, update the slicer's title to reflect what it's filtering. A title like "Filter by Region & Category" tells the user exactly what to expect.

Final Thoughts

While Power BI doesn't allow multiple distinct fields in a single slicer out-of-the-box, you now have a toolkit of effective solutions. You can use built-in hierarchies for structured data, create flexible concatenated columns with DAX for unrelated fields, and even explore custom visuals for more advanced filtering needs. Selecting the right method depends on your data and the experience you want to provide.

Creating these kinds of advanced reports in traditional BI tools often means spending hours learning DAX, hunting for the right visual, or manually shaping your data. At Graphed, we've built a platform that removes this friction entirely. Instead of configuring complex visuals yourself, you can simply ask for what you need in plain English - like "show me a dashboard comparing sales by region and product category for each sales rep" - and the report is built for you instantly, using live data from your connected sources. This allows you to spend more time on strategy and less time wrestling with tedious report setup and customization. To see how easy reporting can be, check out Graphed and start getting answers in seconds.

Related Articles