Forum Discussion
Solved
Ragged Hierarchy in Direct Query Mode
Hi, I have been trying to create a matrix visual containing a ragged hierarchy. I managed to get the matrix to display the way I wanted it in import mode, using the PATH function and creating the...
I actually found the solution to this on another post!
See Anonymous 's solution in the link below:
https://community.powerbi.com/t5/Desktop/Ragged-hierarchy-Visualization/td-p/162892
Thanks!
Hello lglglg_ ,
If your trying to build a matrix visualization in PBI with ragged hierarchies, you may also want to try formatting your matrix to have the expand, "+", icon to drill down on each row level. having the expand button will let display only the parents and children you want to show. In this way, you can prevent showing blank or repeating children for any given parent.
To get the expand icon on your rows, go to the formatting paintbrush, and search "+". the '+/- icons' should appear. turn this option on.
Hope this helps, Power on!