Forum Discussion
Remove Blank Rows in Matrix
Hi Donerandparmo1 ,
Thanks for reaching out to fabric community.
I have created a power bi file based on my understanding. I have unpivoted the columns and calculated columns to represent the data.
If the file doesnot meet your requirements please let us know you query in details so that we will try to reproduce what you want.
Thanks!!
Use Power Query to unpivot Level 2 through Level 5 and remove the blank values, then build a clean parent→child structure, the Matrix will then show the hierarchy correctly without empty spaces https://community.fabric.microsoft.com/t5/Desktop/Having-issue-with-Ragged-hierarchy-in-matrix-visualization/td-p/4872156.
Practically: create one column that concatenates only the non-blank levels into a single path/label per row (e.g., "PIPING" for the parent's own line, "PIPING > Barred Tee" for the child), and drive the matrix from that instead of 5 separate Level columns.
Hi,
Thanks for the response.
Not sure if I fully understand, but I have unpivoted all the WBS columns, and then simply placed into a matrix as such:
The issue with this is that I cannot identify which WBS Level 3s come from which WBS Level 2s, does this make sense?
Cheers