Removing 0 values in matrix

[Anonymous]

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!

[RichardJ]

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 · Accepted solution]

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]

@Anonymous Am glad you found a solution

[Pragati11]

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