topic Re: Bar chart Data Label value display error in Report Server

Bar chart Data Label value display error

CertitudeSeeker — Thu, 27 Jun 2024 01:32:27 GMT

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?

Re: Bar chart Data Label value display error

tharunkumarRTK — Thu, 27 Jun 2024 02:10:30 GMT

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

Re: Bar chart Data Label value display error

CertitudeSeeker — Thu, 27 Jun 2024 02:29:53 GMT

No, that doesn't solve the issue.

Re: Bar chart Data Label value display error

tharunkumarRTK — Thu, 27 Jun 2024 02:37:19 GMT

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

Re: Bar chart Data Label value display error

CertitudeSeeker — Mon, 01 Jul 2024 00:53:26 GMT

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