Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
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.
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.
User | Count |
---|---|
4 | |
4 | |
2 | |
2 | |
2 |