Forum Discussion
Hide/remove matrix rows
Dear Friend, i have one table with Level1,Level2,Level3,Level4 and value, i want to display in Matrix with hierarchy. Data: Level1 Level2 Level3 Level4 value Asset current bank bank1 ...
If you replace the hierarchy in rows of the matrix with the individual lvl 1 - 4 fields it still works in the sample PBIX file I uploaded.
I understand why it doesn't work for me. the column is not empty. this will work:
Ah yes, apologies - i forgot to mention i also used Power Query to change the empty cells to null before using DAX, but yes this would be another way to do it without Power Query.
