Different sums between table and line plot

[dan973]

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 🙂

[v-zhangti]

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 · Accepted solution]

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.