Forum Discussion
Remove Blank Rows in Matrix
Hi All,
I have a 5 level matrix (for example), which includes rows that are empty, due to some values having 5 applicable levels, and others less.
The matrix simply shows the hierarchy as rows, with an ID below each applicable row:
How can I remove the blank row in WBS Level 4 above "Barred Tee" for example.
I've looked at solutions online, and none of them seem to work in this instance, as I don't believe I have a measure.
Cheers!
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!!
8 Replies
Hi,
Are WBS Level 2-5 calculated columns built from a Path/PATHITEM function on a Parent-Child structure, or are they already separate flat columns coming from your source table from Power Query or the database ?
Hi,
Separate columns:
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 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!!
Hi Donerandparmo1 ,
Could you please review the solution provided above and let us know if you have any further questions.
Thanks!!
Hi Donerandparmo1 ,
Have the provided solution helped in resolved your issue? If you still have any additional questions, please let us know.
Thanks!!
