Bar chart Data Label value display error

[CertitudeSeeker]

I am seeing a strange issue here. For months, this report has been working fine and now I see some issues with some records. The below chart shows the sum of the quantity against the Employee Description. As seen in the tool tip, the value should be 0. There are both positive and negative values in the transactions totalling to 0. But instead it displays an exponential number 9 x 10^(−15). However, if I put the same in a table, the total comes to 0, which is correct. But on the bar chart it shows as the exponential value. Has anyone come across this issue? Can it be resolved or is it a PowerBI bug?

[tharunkumarRTK]

@CertitudeSeeker 

Please check the format you used for data labels, try reducing the decimal points to 2 and see if solves the problem.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[CertitudeSeeker]

No, that doesn't solve the issue.

[tharunkumarRTK]

@CertitudeSeeker 

What is the format string of this measure? can you try changing the measure format string to decimal and keep decimal points as 2 or 1 and see if that helps. I have seen this issue happening with visual axis labels and data labels and correcting the format string solves the problem.

I am guessing your might have selected the decimal points for this measure 'Auto'.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[CertitudeSeeker]

No mate. If I had selected 'Auto', it wouldn't have changed from -9E-15 to -8.88E-15.