Forum Discussion
PDE
2 years agoRegular Visitor
Recreate structure in matrix without empty row values
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!