Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Hide empty hierarchy levels in Matrix visual

When using a hierarchy that has multiple levels, blank rows are displayed in the Matrix visual.

The custom visual "HierarchySlicer" allows these 'empty leaves' to be hidden.


Please add this option to the Matrix visual as well!

Status: New
Not applicable

THIS!! Our organization has many ragged hierarchies with some going down 10+ levels. It is a MASSIVE pain to accomodate because it just leads to users expanding the same value a number of times and makes the hierarchy filter very cumbersome to use. Other programs like SmartView/Essbase and even SSAS (I believe) offer the ability to suppress these duplicate or blank levels.


This would be an amazing feature to have at the hierarchy level and not just specific to matrix.

Regular Visitor

This is available as a feature in the custom visual; Financial Reporting Matrix:

Frequent Visitor

@Ahaano Yes, but it will cost you 297 euros a year. Not a great solution for many.

Regular Visitor

This is very typical for a chart of accounts or country eg: compare USA to New Zealand - No states in New Zealand or counties


Seems like basic ability a BI should absolutely have even before a pie chart.

Regular Visitor

Very needed! Please include it in your backlog, it seems like an easy fix 🙂

The same idea is posted here: Matrix: Hide Expand icon when no drill down data for item.

Frequent Visitor

also the same for normal slicer custom visual. With hierarchy slicer you can not have dropdown list.