Forum Discussion
Removing Blanks from Matrix with Ragged Hierarchy
Hi, I have a ragged employee hierarchy with different lengths that looks like the below: I also have a list of Account Names and Account Owners. I also have total spend for each of t...
Hi Anonymous ,
As a best practices from data point of view, I suggest you clean your BLANK values. Replace Blanks with some text value.
Thanks,
Pragati
This would also look silly as there would be many repeat values. Was hoping for a workaround so I could just expand the first Hilary only.
Based on the link below, it is not possible in the default Matrix visual (with blanks in the data).
The link suggests some alternatives to consider (like no-stepped layout, custom visual ... )https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual
