Visualize data with different hierarchy/level in Matrix visual(in other visuals as well)

[Muhiddin]

When visualizing data which has different hierarchy levels in Matrix table(in other visuals as well like tree map and so on), it is showing expand(+) even there is no data for that hierarchy/level.

For example, Some data has 3-level hierarchy(full hierarchy, the first and second rows), while some other has only 2-level hierarchy( like below third row does not have any data for hierarchy3

hiearchy1 hiearchy2 hiearchy3

aaa bbb ccc

aaa ddd eee

aaa fff

When you visualize above table in matrix there expand (+) is enabled in hierarchy2 of "fff" even there is no data after it in hierarchy3.

Idea:

Would be nice if Power bi can evaluate above data structure and do not display expand(+) in Matrix visual, if there is no data in next hierarchy or the same data.