What Is a Hierarchical Slicer?
A hierarchical slicer filters data across nested levels — Category → Subcategory → Product, Region → Country → City, Department → Team → Employee — where selecting a value at one level reveals (or filters) the values available at the next level down.
It's the difference between a flat list of every product in your catalog, and a structure that lets someone pick a category first, see only the subcategories that exist within it, then drill into a specific product — the way the data is actually organized.
Why a Flat Filter Breaks Down
A single flat slicer works fine when a category list is short and unstructured. It stops working once the list has real hierarchy: a catalog with 40 categories, 300 subcategories and 5,000 products can't reasonably be filtered from one flat list — either it's unusably long, or the structure that would make it navigable (grouping) is missing entirely.
Power BI's native slicer doesn't support hierarchical drill-down interaction at all — hierarchies work in visuals like matrices and tables, but not as an interactive filter control.
What a Good Hierarchical Filter Needs
- Progressive disclosure — child values should only appear once a parent is selected, keeping the interface manageable regardless of total catalog size.
- Clear drill vs. filter distinction — clicking a value should filter the report, but browsing deeper into the hierarchy without committing to a filter is a separate, equally important interaction.
- Multi-selection support — real use cases often need "Category A AND Category C," not just a single path down the tree.
- Visual distinction per level — level 1, level 2 and level 3 selections should be visually distinguishable, so the reader can tell at a glance how deep the current filter goes.
Chip Slicer Hierarchy for Power BI
Chip Slicer Hierarchy extends the chip/pill interaction pattern across up to three nested levels: Category → SubCategory → Product. Click a chip to filter — child chips expand automatically underneath it. Click the expand icon (▸) to browse a branch without committing to a filter.
What it adds
- Up to 3 hierarchy levels (Pro) vs. 2 on Free.
- Unlimited values per level (Pro) vs. a 20-value cap on Free — needed for any catalog of real size.
- Multi-selection across levels (Pro) — select multiple branches simultaneously, not just one path.
- Custom per-level colors and typography (Pro), so each depth is visually distinct.
- Auto-collapse siblings (Pro) — collapse other branches automatically when a chip is selected, keeping the control compact even with a large hierarchy.
- A configurable reset button to clear all filters across every level at once.
Getting Started
- Drag a Category field into the Level 1 well.
- Add a SubCategory field to Level 2 (optional).
- Add a Product field to Level 3 — Pro only (optional).
- Click a chip to filter — child chips expand automatically.
- Click the expand icon (▸) to browse without filtering.
If your catalog or org structure has real depth to it, a hierarchical chip filter lets readers navigate that structure directly, instead of forcing a flat list to represent something that was never flat to begin with.