Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CertitudeSeeker
Frequent Visitor

Bar chart Data Label value display error

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?

CertitudeSeeker_0-1719450957899.png

 

4 REPLIES 4
tharunkumarRTK
Super User
Super User

@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



No, that doesn't solve the issue.

 

CertitudeSeeker_0-1719455367909.png

 

@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



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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors