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   Company IN OUT Tesla $100.00 $0.00 Microsoft   $0.00 Square $100.00 $100.00   I want to remove the lines that have both...
Need Help
  • 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 

Pragati11's avatar
Pragati11
Super User
5 years ago

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