How to Create a Hierarchy Slicer in Power BI

Building an interactive report in Power BI often means giving your users the power to filter data themselves. A hierarchy slicer is one of the best ways to do this, allowing them to drill down from a broad category into specific details without cluttering your report canvas. This tutorial will walk you through exactly how to create and customize a hierarchy slicer so you can build cleaner, more user-friendly dashboards.

What is a Hierarchy Slicer and Why Should You Use One?

Before jumping into the "how," let's quickly cover the "what" and "why." In data, a hierarchy is a logical relationship where data is organized into levels. Think about a time-based hierarchy: Year > Quarter > Month > Day. Or a geographical one: Country > State > City.

A standard slicer in Power BI is a visual filter. You drop a field like "Country" into it, and users can click on a country name to filter all the visuals on the report page. It's simple and effective.

A hierarchy slicer combines these two concepts. Instead of creating separate slicers for Country, State, and City — which would take up a lot of valuable dashboard real estate — you can combine them into a single, expandable slicer. Users can see the highest level first (e.g., a list of countries), click an expand icon next to a country to see the states within it, and then expand a state to see its cities.

The Main Benefits of Using a Hierarchy Slicer

• Better User Experience (UX): It’s an intuitive way to explore data. Users naturally understand the concept of drilling down from general to specific, and this slicer mirrors that thought process.
• Saves Report Space: Combining three or four slicers into one keeps your canvas clean and focused on the key data visualizations, not the filters.
• Guided Analysis: It gently guides users through a logical filtering path, preventing them from getting lost in dozens of unrelated filter options. It encourages a top-down approach to data exploration.

For example, a sales manager could use a single hierarchy slicer to view total revenue for North America, then effortlessly expand it to see the breakdown by the USA and Canada, and finally drill into California to see how it's performing without ever leaving the main dashboard view.

Preparing Your Data for a Hierarchy

Like anything in data analysis, a great visual starts with well-structured data. Power BI can create hierarchies on the fly, but it works best when the relationships are clearly defined in your data model.

For a hierarchy to work, your data table needs to contain columns that represent each level of the hierarchy. The relationships between these levels should be logical parent-child connections. For instance, every value in your "City" column should belong to a value in your "State" column, and every "State" should belong to a "Country."

Example Data Structures:

• Product Data: A table with columns like Product Category, Sub-Category, and Product Name.
• Geographic Data: A table with columns like Continent, Country, Region/State, and City.
• Organizational Data: A table with columns like Department, Team, and Employee Name.

If your data is clean and these columns exist, you're ready to go. You don’t necessarily need to create a formal hierarchy object in Power BI’s data model beforehand, but doing so can keep your Fields pane organized if you plan to reuse the same hierarchy in multiple visuals.

To create a formal hierarchy in the data model (which is optional for slicers), you would go to the Data or Model view, find your table in the "Data" pane, right-click on the highest-level field (like Country), and select "Create hierarchy". You can then drag the other fields (State, City) into that newly created hierarchy.

Step-by-Step: Creating a Hierarchy Slicer

Now, let’s get building. Assuming you have a Power BI report open with your data loaded, follow these steps.

Step 1: Add a Slicer Visual to Your Report

First, find the Visualizations pane on the right side of your Power BI canvas. Click on the Slicer icon (it looks like a funnel with a checkmark) to add a new, empty slicer to your report page. You can resize it and move it wherever you like.

Step 2: Add Your Fields to Create the Hierarchy

This is where the magic happens. With the new slicer selected, look at the Fields well in the active part of the Visualizations pane. This is where you’ll drag your data fields.

Start with the highest level of your hierarchy. For our example, let's use a geographic hierarchy.

• Find your data table in the "Data" pane.
• Click and drag your top-level field (e.g., Country) into the "Field" well of the slicer. At this point, you'll have a standard list slicer showing all the countries.
• Next, find your second-level field (e.g., State) and drag it directly underneath the Country field in that same "Field" well.
• Finally, drag the third-level field (e.g., City) and drop it underneath State.

As you add fields under the first one, Power BI automatically recognizes you're building a hierarchy inside the slicer. You will immediately see little down-facing arrows (chevrons) appear next to the items in your top level.

Step 3: Test and Use Your New Slicer

Your hierarchy slicer is now functional! Interact with it to see how it works:

• Click the arrow icon next to a top-level item (like "USA") to expand it and reveal the next level (the states).
• Click the arrow next to a state (like "California") to expand it further and see the cities.
• Click the checkbox next to any item at any level to apply that filter to your report. You can select an entire country, a specific state, or just a few cities. To select multiple items, hold down the Ctrl key while you click.

Customizing and Formatting Your Hierarchy Slicer

A functional slicer is great, but a well-formatted one makes your report look professional and is easier to use. With your slicer selected, click the "Format your visual" icon (the paintbrush) in the Visualizations pane.

Slicer Settings

Under "Slicer settings > Selection," you can configure how users select items:

• Single select: Only allows one item to be selected at a time. This changes the checkboxes to radio buttons.
• Multi-select with CTRL: This is the default setting.
• Show "Select all" option: Adds a handy "Select all" option to the top of your slicer list.

Hierarchy Formatting

The "Hierarchy" section is where you can adjust the look of the expand/collapse elements.

• Expand/Collapse Icon: You can change the icon from a chevron to a plus/minus sign or a caret. Choose what looks best with your report's design.
• Stepper: Here, you can adjust the Indentation. Increasing this value will push the child items further to the right, making the different levels of the hierarchy much clearer and easier to read. A value of 15–20px usually works well.

Other Key Formatting Options

• Values: This section lets you control the font, color, and text size of the items in your list. You can add a subtle background color to every other line for readability.
• Slicer header: You can edit the slicer's title text, making it more descriptive (e.g., changing "Country, State, City" to "Filter by Location").

Common Issues and Quick Fixes

Hierarchy slicers are generally straightforward, but you might run into a couple of common hiccups.

Problem: I have "(Blank)" showing up in my slicer.

Solution: This happens when you have rows in your data with a child value but no corresponding parent value (e.g., a city listed without a state). The easiest fix is to filter it out. With the slicer selected, drag the same fields you used to create the hierarchy into the "Filters on this visual" section of the Filters pane, open the filter card for the problematic field, and uncheck "(Blank)".

Problem: The items are sorted alphabetically, but I want a custom order.

Solution: Power BI defaults to alphabetical order. If you want to sort months chronologically instead of alphabetically (April, August, December...), you need to use the "Sort by column" feature. In the "Data" view, select the column you want to sort (e.g., Month Name), then go to the "Column tools" ribbon at the top, click "Sort by column," and choose the column that defines the correct order (e.g., Month Number).

Problem: My slicer is very slow to load.

Solution: If your hierarchy contains tens of thousands of items (e.g., filtering every single product in a massive inventory), the slicer can become slow. In such cases, a hierarchy slicer might not be the best tool. Consider using the dedicated Filter Pane instead or guiding users through a drill-through page for exploring such granular data.

Final Thoughts

Hierarchy slicers are a fantastic tool in any Power BI developer's toolbox. They declutter your reports, provide an intuitive user experience, and give users a powerful way to explore data from a ten-thousand-foot view right down to the nitty-gritty details, all within a single visual element.

While mastering tools like Power BI opens up a world of possibilities, it also comes with a significant learning curve. You have to learn your way around panes, settings, and data models just to get basic answers. At Graphed, we felt this pain, which is why we built a tool that automates the reporting busywork. You can connect all your data sources - from Google Analytics to Shopify and Salesforce - and build real-time dashboards just by describing what you want to see in plain English. This gives everyone on your team the power to get immediate answers from their data without becoming a BI expert.