Forum Discussion
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 blank and zero
Thanks!
- Anonymous5 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
- Pragati11Super User
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
- RichardJResponsive 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
- AnonymousNot 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
- RichardJResponsive Resident
Anonymous Am glad you found a solution