Forum Discussion

dan973's avatar
dan973
New Member
3 years ago
Solved

Different sums between table and line plot

Hello everybody ! I'm a beginner in Power BI. I have a table with country, year and population value columns.      On Power BI, when I set a line plot, the sum of the population value pe...
Need Help
  • dan973's avatar
    dan973
    3 years ago

    Hi v-zhangti,

     

    Thanks for your response but I have found the issue. It was because during the data format conversion, Excel removed the last character after the decimal if it was 0, so Power BI treated a 5 number population instead of a 6 number population.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, dan973 

 

Can you provide more sample data for testing? Sensitive information can be removed in advance. You can also show it with pictures or Excel. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

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

dan973's avatar
dan973
New Member
3 years ago

Hi v-zhangti,

 

Thanks for your response but I have found the issue. It was because during the data format conversion, Excel removed the last character after the decimal if it was 0, so Power BI treated a 5 number population instead of a 6 number population.