Hierarchy Suppress If Blank

[UncleLewis]

Hi,

I have a jagged hierarchy.

It is possible to only show the parent with no + symbol indicating there are no children below the parent?

Thanks,

-w

[UncleLewis]

Thanks Amitchandak,

Unfortunately neither of those links address the issue appropriately.

1. This link is for Custom Hierarchy Slicer from Appsource.
I cannot use custom apps from appsource. Control by Admin.
I do not want to use separate vis. I want to use only Matrix.

2. The idea presented is to turn off stepped layout on Rows.
In that case, you just have Tabular Layout might as well use a Table vis.
I am trying to compress space side-to-side so user does not need to scroll left to right
So I need Stepped Layout to remain turned on.

Any other ideas to not display blank rows in Matrix Hierarchy?

Thanks,
-w

[v-xiaotang]

Hi @UncleLewis 

I am afraid it's not possible if you want to remove + from rows where value is blank. 

As an workaround, you can add "null" on the rows where value is blank, see below

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@UncleLewis , refer if these can help

https://forum.enterprisedna.co/t/control-blanks-in-hierarchy/19153/9

https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual