Recreate structure in matrix without empty row values

[PDE]

I want to recreate a workbreakdown structure via a matrix visual in PowerBI.

In Excel (screenshot 2) I have the structure that contains a column value for each branch level. Not all branches contain 5 levels.

In the matrix visual (screenshot 1) I add all levels (columns) as rows and unfortunately also the smaller branches can be expanded upto 5 levels (of which some levels are thus empty). My hope was to be able to filter out the blank rows in the visual but no luck...

Has anyone got an idea how to handle this?

Thanks in advance!

[Ahmedx · Accepted solution]

Refer to this solution

https://community.fabric.microsoft.com/t5/Desktop/Hide-remove-matrix-rows/m-p/3544663#M1168557

[PDE]

Hi @Ahmedx and thanks for the quick reply! The measure solution works perfectly. Any idea how to get rid of the remaining expand/collapse buttons? They keep showing at levels where a branch ends.