Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Removing 0 values in matrix

Hi everyone,

 

So I have this matrix/table in BI

 

CompanyINOUT
Tesla$100.00$0.00
Microsoft $0.00
Square$100.00$100.00

 

I want to remove the lines that have both blank and zero

 

Thanks!

  • Anonymous's avatar
    Anonymous
    5 years ago

    I want to remove that row only. If I use the filter in any of the 2 columns it filters out the whole line which is not what I want.

     

    Instead of trying to filter, I changed the calculated columns to show blanks instead of zero and that solved the problem 

4 Replies

  • Hi Anonymous ,

     

    You can use a Visual level filter on your matrix visual to achieve this.

    For example if you want to remove any rows from matrix where values for OUT is 0. Then just apply a visual level filter for OUT on this visual.

     

    Thanks,

    Pragati

     

    Thanks,

    Pragati

  • RichardJ's avatar
    RichardJ
    Responsive Resident

    Hi Anonymous - In the matrix, can you clarify whether you would like the Microsoft row still to be shown as an empty row despite it having blank and zero values? 

     

    If you would like the blank/0 Microsoft row to remain,  you could conditionally format the IN and OUT values to have the same colour of font as the background when the value equals 0.

     

    This would mean that the zero value would be in the grid (and the row would remain) but the user wouldn't see the value so it would look 'empty' to them.

     

    Cheers,

    Richard

    • Anonymous's avatar
      Anonymous
      Not applicable

      I want to remove that row only. If I use the filter in any of the 2 columns it filters out the whole line which is not what I want.

       

      Instead of trying to filter, I changed the calculated columns to show blanks instead of zero and that solved the problem 

      • RichardJ's avatar
        RichardJ
        Responsive Resident

        Anonymous Am glad you found a solution