Data color is showing negative bar for 0.0 value.

[pracy]

We have 2 bar postive and negative. if value is 0.0, it is showing negative, Which is not correct. Please halp on this.

[jthomson]

Are you sure the data involved is actually 0, and not some very small negative value that's rounding to zero based on your number of decimal points formatting?

[pracy]

Yes, I just checked. the value is -0.03. But if i want to show it at 1 decimal place. How I can resolve it. Data with data color

[jthomson]

If you want to deny that -0.03 is, in fact, negative, then do some rounding in the actual measure itself so that the value you get out is actually zero, not just displaying as such - something like newmeasure = mround([existingmeasure],0.1) should do the trick

[Mariusz]

Hi @pracy 

If you want to show as 1 decimal place then please refer to my previous post

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz]

Hi @pracy 

Can we see the screenshot of conditional formating settings 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[pracy]

Hi @Mariusz 
Conditional formatting:

And also whereI am showing it, screenshot:

Fied formatting:



Thanks

[Mariusz · Accepted solution]

Hi @pracy 

I think the problem is the field value formating, try applying formatting directly on your measure instead.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn