Hide empty hierarchy levels in Matrix visual

[wes-verh]

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!

[Anonymous]

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]

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

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

[djs1984]

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

[satori-pbi]

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]

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]

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