SUM of Column Values Showing Incorrect in Charts

[Garry030424]

As you can observe in the following image, sum of few things is showing incorrect in power BI charts.

Kindly Suggest.

I tried doing sum in excel and it shows 0.0 not sure why its incorrect in the PowerBI chart 

[v-heq-msft]

Hi @Garry030424 ，
Based on your description, I did some testing and this may be due to the size of your data being too different and the inappropriate choice of display effects you used in visualization. Rounding is done when the difference between your data and the selected magnitude is too large.
Million

None

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Kedar_Pande]

Create a new measure:

Rounded_Sum = ROUND(SUM(YourTable[YourColumn]), 2)

Sometimes, even very tiny decimal values can be present in your data due to precision issues. You can add a calculated column to check for small values and force them to zero:

Corrected_Column = IF(ABS([YourColumn]) < 0.0001, 0, [YourColumn])

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

[Kishore_KVN]

Hello @Garry030424 ,

In excel the values might be saved in that 5E..+02 format. You may have formatted them as number but still their meta data might be the same. So to handle this in Power Query Editor itself start check the values in that number column and fix them there. If you cant fix it there, then please fix it in excel saying it as text and then in Power Query please change it to number. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Garry030424 · Accepted solution]

@Kishore_KVN : Thanks for suggestion, editing datasource wasn't possible thus i have created a new column wherein i have used Value function and then changed data type to Fixed Decimal