Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago

Hide Matrix column values which has Zero

Hello folks,

I have matrix table here 

But When I filter applied, it looks as below.

I don't want to see all the columns which has zero both.

 

Is there any possible way to hide rows which has Zero values in both coloumns after applied filter?

 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    On the right side you have filter visual. Unselect 0 value on them if you want to get it done quickly strictly for visual.

     

    The row content shows you "all" like its written

      • amitchandak's avatar
        amitchandak
        Super User
        3 years ago

        Karthik12 , because it and, there now value where both of them are non zero, what I got from screenshot 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    If the two columns you have shown are created with the dax formula, you can convert the conditions that are 0 to blank() in this setting.

    IF(x=0,blank(),x)

    If you do this operation, the row will not be reflected when both columns are blank in the matrix.

    if the second option

    You can create a separate column and check these two values together.

    zeroCheck=IF(Plan Qty=0 && Production Qty=0,false,true)

    then just filter out those zeroCheck is true in your filter.

    • Karthik12's avatar
      Karthik12
      Post Patron
      3 years ago

      Anonymous Thanks. It looks woking fine. Filter not enabling to filter 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

         

        here i created a demo for you,

        Best regards,

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