Advanced Hierarchy Filtering in Power BI 

Are your Power BI reports struggling with complex data navigation? Do users get lost drilling down through endless levels? Traditional Power BI filters often fall short, making granular data exploration a frustrating experience. This is where advanced Power BI hierarchy filters become essential.  

In this comprehensive guide, we'll delve into the process of setting up and optimizing hierarchy filters in Power BI, and crucially, reveal how Inforiver Super Filter (and it’s free forever!) enhances this process with unparalleled flexibility, dynamic logic, and enhanced control, making it the ultimate slicer for Power BI. 

Why Inforiver Super Filter? 

Inforiver Super Filter offers a modern take on hierarchy filtering in Power BI, designed to simplify and streamline the user experience. It brings flexibility, clarity, and enhanced control to hierarchical data navigation. In the sections that follow, we’ll explore how Super Filter elevates the filtering experience with features that go far beyond what's available in native slicers.

Figure 1: Hierarchy Filter in Inforiver Super Filter 

Inforiver Super Filter vs. Native Power BI Slicers: A Hierarchy Filtering Showdown

How to Set Up Hierarchy Filters in Power BI 

Create a Power BI hierarchy filter in minutes! To unlock the full power of hierarchy-based filtering with Inforiver Super Filter, simply: 

1. Add columns to the “Category” data field in the visual. 

2. Disable “Facet Mode” in the settings to activate Hierarchy Mode. 

Figure 2: Disabling the Facet Filter to enable the Hierarchy Filter 

3. Add a Measure to the "Others" data field if you want to use it for displaying additional details or dynamic filtering. 

Figure 3: Measure Data added to the Other data fields 

Once configured, Super Filter turns into a powerful hierarchy navigator and analyzer with the ability to drill down, format, filter by values, and much more. For more information on the Hierarchy Filter, please refer to the technical documentation. 

Getting Started with Hierarchy Filtering in Super Filter 

To enable hierarchy-based filtering: 

1. Add columns to the “Category” data field in the visual. 

2. Disable “Facet Mode” in the settings to activate Hierarchy Mode. 

Figure 1: Disabling Facet Filter to enable Hierarchy Filter 

3. Add a Measure to the "Others" data field if you want to use it for displaying additional details or dynamic filtering. 

Figure 2: Measure Data added to the Other data fields 

Once configured, Super Filter turns into a powerful hierarchy navigator and analyzer with the ability to drill down, format, filter by values, and much more. For more information of Hierarchy Filter Please refer to the Official Documentation. 

Why Super Filter Is the Best Choice for Hierarchical Filtering: 

1. Flexible View Types: Checkbox, Radio, and List 

Super Filter supports multiple visual styles for hierarchy filtering—checkboxes for multi-select, radio buttons for single-select, and compact lists for clean designs—configurable per use case. 

• Use Case: If a report designer wants users to select only one Region at a time in a clean and compact layout. 

• How Super Filter Helps: Super Filter provides multiple view types, such as radio buttons for single select, checkboxes for multi-select, and list views for space-efficient filtering—adapting easily to design needs. 

Figure 4: Checkbox, Radio and List view types in hierarchy filter 

2. Multi-level Search 

The search bar in Super Filter supports multilevel search, meaning it searches across all hierarchy levels such as Region, Country, and City. When a user types a value, it displays matching items regardless of their position in the hierarchy. Additionally, it supports wildcard characters (e.g., *, ?) and operator-based search (e.g., >50000, <10%) when used alongside measures—making search more dynamic and intelligent. 

• Use Case: If a user wants to quickly find "Texas" in a deeply nested hierarchy like region > Country > State or filter all subcategories where Profit Margin is <10%. 
  
• How Super Filter Helps:  With wildcard and operator-based search, allowing users to type inputs like Bik* to match terms starting with "Bik" or >50000 to filter values above 50000. The search applies across all levels in the visual and auto-expands matching paths for easy discovery.

GIF 1: Multilevel search in hierarchy filter using the search bar in toolbar 

3. Show Measure Details for Each Item 

When you place a measure into the 'Others' section, it appears as a detail next to each hierarchy item, showing KPIs like Sales, Profit, or Quantity. This provides additional information to the users to make the selections. 

• Use Case: If a product analyst wants to review the quantity sold for each product subcategory directly within the filter before making selections. 

• How Super Filter Helps: By placing the Quantity Sold measure into the 'Others' field, Super Filter displays it next to each subcategory, helping users make informed choices without switching visuals. 

 Figure 5: Sales measure shown as details for each leaf level item 

4. Variance using measure values 

When two measures are added to the “Other” field, variance mode can be enabled to calculate and display the difference between the selected measures, along with positive/negative indicators. This functionality is natively available in Super Filter, requiring no extra visuals or DAX. 

• Use Case: If a Regional Head wants to compare actual Revenue vs. Target Revenue for each product to identify performance gaps. 

• How Super Filter Helps: Super Filter calculates and displays variance directly in the slicer using two added measures, along with trend indicators—no extra visuals or DAX needed. 

Figure 6: Variance highlighted using icon-based on the measure values added. 

5. Conditional Formatting for Enhanced Insights 

Conditional formatting lets you visually distinguish items in the hierarchy based on measure logic, such as applying colors or styles to highlight specific conditions. These rules can be saved as presets, making it easy to filter and focus on items that meet defined business criteria without manually scanning the list. 

• Use Case: If a finance team wants to quickly identify underperforming products with Profit Margin < 10% in their hierarchy. 

• How Super Filter Helps: Super Filter uses conditional formatting to automatically highlight such items (e.g., in red), drawing immediate attention to problem areas based on predefined business logic. 

Figure 7: Sales > 100k is highlighted by a green background color using conditional formatting. 

6. Sorting & Ranking 

Super Filter also offers dynamic Top-N or Bottom-N filtering directly within the visual, allowing users to rank items based on a selected measure. It also enables sorting either alphabetically or by measure values across hierarchy levels. This eliminates the need for DAX-based workarounds and enhances user interactivity. 

• Use Case: If a business user wants to see only the Top 10 Customers by Revenue or sort customers by sales performance within a region. 

• How Super Filter Helps: Super Filter allows users to either apply Top-N ranking or perform sorting within the hierarchy—by measure values or alphabetically from format pane of the visual. These options work independently, enabling focused analysis and exploration without the need for DAX or additional visuals. 

Figure 8a: Hierarchy filter Sorted in descending order based on Sales measure. 

Figure 8b: Hierarchy Filter ranked by Top 3 based on Sales measure 

7. Smarter Parent-Child Single Selection 

Normally, selecting a parent node selects all children—but with Leaf Node Single Select, only the first child gets picked, giving more precise control. 

• Use Case: If a user selects "Accessories" but only wants the first child region ("Bike Racks") to be auto-selected instead of all underlying countries. 

• How Super Filter Helps: The Leaf Node Single Select feature ensures that only the first child of a parent node is selected, offering more precise control and avoiding over-selection. 

GIF 2: Leaf node single select customisation in Hierarchy Filter 

8.Combine Hierarchy and Measure Filters  

Inforiver Super Filter allows you to layer a numeric measure filter alongside a category-based hierarchy. This lets users interactively filter hierarchical items based on a selected value range of a DAX Measure (e.g., Sales, Profit). 

• Use Case: If a sales manager wants to analyze only the products having PY Sales > $50,000 in the report. 

• How Super Filter Helps: Super Filter allows the manager to filter through a product hierarchy (e.g., Product Category → Subcategory) using a dynamic sales measure slider, enabling both category-based and numeric filtering in a single, streamlined visual. 

Here is a GIF showcasing Dynamic Measure-based filtering for a Country -> Category -> Products hierarchy: 

GIF 3: Dynamic filtering using measure slider based on sales measure 

9. Rich Formatting Options for Better UX 

From expand/collapse icons to font styling, indentation, alternate row coloring, and utility icons—Super Filter offers full visual customization of the hierarchy tree. 

• Use Case: If a report designer wants to improve visual clarity by bolding parent nodes and alternating row colors for better readability. 

• How Super Filter Helps: Super Filter provides rich formatting options like font styling, row coloring, icons, and indentation, resulting in visually consistent, brand-aligned, and user-friendly reports. 

Conclusion 

The Inforiver Super Filter transcends the limitations of a standard Power BI slicer. It's a comprehensive solution for advanced hierarchical filtering in Power BI, empowering users with intuitive drilldown filter Power BI capabilities, multi-level search, dynamic measure-based filtering, and stunning conditional formatting. For any team looking to streamline complex Power BI filter options and drive faster, more informed decisions, Inforiver Super Filter is the essential upgrade (and it’s free forever!). Don't just filter data; truly explore it. Try it on Microsoft AppSource today and transform your Power BI data exploration experience!