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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Comments
Anonymous
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.

Ahaano
Regular Visitor

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

https://youtu.be/L-3vDo8Dj2k?t=119

djs1984
Frequent Visitor

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

satori-pbi
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.

Mirowska
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.

sarabaia
Frequent Visitor

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