Add a hierarchy filter

Use the hierarchy filter to browse and filter hierarchical data through expandable levels. Expand or collapse parent members and select values at any level to quickly narrow the report to the required subset of data.

Configure a hierarchy filter#

Use hierarchy filters to navigate and select categories from multiple hierarchy levels.

  1. Add a Super Filter visual.
  2. Assign a hierarchical dimension to the Category bucket.
  3. In the Filter ribbon, select Hierarchy from Quick Mode.
  1. In the Filter ribbon, go to Properties to apply customizations, such as tile selection method or appearance.
Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.