Forum Discussion
Rows in Matrix - Many levels - present data without blanks on higher level
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?
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
2 Replies
- Ritaf1983
Super User
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
Thank you Ritaf1983 this soultion works for me! 🙂
