Power BI overstating values

[angelaalkatib]

Power BI is overstating the values compared to my Excel data source by about 5,600. 

I think this has to do with my 4 data sources and/or the relationships set up between them, but I cannot for the life figure how what it is that is causing it.

Power BI Values and Data SourcesExcel file valuesRelationships between data sources

I made sure the Excel sheet is including everything that Power BI is including (like filters and things like that) and I even deactivated the Power BI Relationships one by one AND all of them at the same time... this did not fix the problem.

Does anyone have any ideas why this is happening??

[angelaalkatib · Accepted solution]

I figured this out. Power BI was rounding the numbers. 

At first, I changed the number format to Decimal number instead of Whole Number, but that didn't work.

Then I changed the number format in the Query settings and that seemed to do the trick!!