Stacked Column Chart showing incorect value

[smjzahid]

I have a stacked column chart and it connect to an excel file usig excel connector. I DO NOT have any filter applied in the report nor on any visual. 

The value being shown on the visual is 379 where as the actual value at the backend excel file is 378 (see below)

See the visual below it show 379, dont know why?, I have refreshed the data, in Power Query and then refresh all the visual in PBI Desktop using the Reresh all button on top ribbon

[v-jingzhang]

Hi @smjzahid 

What is the data displayed in Power Query Editor, 378 or 379? What is the data type in Excel? Is there any possibility that it has some fraction digits actually but formatted to round down or round up to a whole number in Excel or in Power Query?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@smjzahid Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please check is it because of decimal place issue