Forum Discussion
How to make no data rows invisible?
In a report, I wish I can hide those rows without data in them.
For example,
Toronto Server_A num_1 num_2 num_3
If num_1,num_2 and num_3 are zeros, then this row will be hidden.
How to make it?
Hi Anonymous
You can create flag measure like:
flag = if([num1]=0 &&([num2]=0&&([num3]=0,0,1)and then use this measure as a visual filter
flag = 1please see the solution of @v-rzhou-msft in the linked discussion including the sample file:
https://community.fabric.microsoft.com/t5/Desktop/Hide-Rows-in-Table-Matrix/m-p/3255654If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous
You can create flag measure like:
flag = if([num1]=0 &&([num2]=0&&([num3]=0,0,1)and then use this measure as a visual filter
flag = 1please see the solution of @v-rzhou-msft in the linked discussion including the sample file:
https://community.fabric.microsoft.com/t5/Desktop/Hide-Rows-in-Table-Matrix/m-p/3255654If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly