Hide rows in matrix

[Anonymous]

I have Matrix table with 3 measures 

Abc	120
NNN	0
Xyz	50

i need to reomve row NNN with 0 value

Please advice me to sort this

Thanks 

[Ashish_Mathur]

Hi,

Write this measure.  Measure1 is the measure that returns 120,0 and 50:

=IF(ISBLANK([Measure1]),BLANK(),[Measure1])

Hope this helps.

[v-yulgu-msft]

Hi @Anonymous ,

I'm afraid this is not achievable, currently, it is not supported to hide/show row conditionally based on values.

Best regards,

Yuliana Gu

[Gordonlilj]

Hi,

You could use the filter pane to filter the values.

Either by using basic filtering and remove the value or use the advanced filtering and remove the row when the value is 0.

[Anonymous]

Its not allow to do filtering, 

i think all are mesures