Forum Discussion
Rows in Matrix - Many levels - present data without blanks on higher level
- 2 years ago
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
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! 🙂