Table conditional formatting is not consistent

[wverheijen]

Hi,

I have a table visual with a calculated column. This column has a conditional formatting which makes the background red if the value is higher than 0.

This works pretty good, but in some cases even a "0,00" value turns red, while others don't.

Is this a bug or can I fix this and how?

[v-jiascu-msft]

Hi @wverheijen,

Can you share the file please? You can delete the private parts first.

Best Regards,

Dale

[Anonymous · Accepted solution]

@wverheijen,

You probably have some fraction in your calculated column, lets say 0.00012. To avoid that, you could round the column using ROUND function