Rows in Matrix - Many levels - present data without blanks on higher level

[BIDeveloper_]

Hello,

I have Power BI Matrix where in Rows I have Parent Child Hierarchy and Product Name.

For some rows I don't have Level 3 so I would like to present Product below Level 3 not just presenting EMPTY Level 3 (Blank).

Can I ask you for a help ? It is possible to omit those rows in Matrix where we have blank but still keeping the lowest level? 

[Ritaf1983 · Accepted solution]

Hi @BIDeveloper_ 
There is no option to "skip" blank hierarchies but there are some workarounds to avoid "opening" of blank rows.
Take a look at the linked video :

https://www.youtube.com/watch?v=YEuxONjCl1A

This article :

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

And i attached pbix with an example

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

[BIDeveloper_]

Thank you @Ritaf1983 this soultion works for me! 🙂