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 per year is different from the table.

 

For example, on the table, the world population in 2005 is 7.9 Md. On the graph, the result is 6.3 Md.

 



Any ideas about this issue ?

Thanks in advance for the support 🙂

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.

2 Replies

  • 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.