Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hide rows in matrix

I have Matrix table with 3 measures 

 

  
Abc120
NNN0
Xyz50

 

i need to reomve row NNN with 0 value

Please advice me to sort this

 

Thanks 

 

Need Help
Tips and Tricks

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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's avatar
    Gordonlilj
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Its not allow to do filtering, 

      i think all are mesures  

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

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

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

    Hope this helps.