Conditional formatting in Matrix viz

[NithinBN]

Hello All, 

I have my table like this, 

In that Table, Dept-2 doesnot have any student. 

I am using Marrix Viz and this is how its defined, 

and result is shown like this. 

Is there any way by which I can hide empty rows from Dept-2 (I wan to show Dept-2 in that table but not its empty childrens.)

Thank You!

[Anonymous]

Hi @NithinBN ,

If you only want to hide empty student, you can use filter to remove blank.

Due to you add these five columns in matrix row field, so you couldn't hide empty value in low level and still show value in high level. Because it is contradictory.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Padycosmos]

Hope this Microsoft document helps.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#ragged-hierarchy