Showing results for 
Search instead for 
Did you mean: 

Values in table from excel table don't match the values in the table.

Values from chart don't match the table that in the excel tool. 

















You should expect the numbers to add up, given that the same filters are applied. However the values add up differently. This is the same if the filters are removed, and all other widgets on the page are taken away. I can reproduce the issue. 

Status: Needs Info

@williamh ,

Could you please share the sample data of your original table? Also we would need to know which field you use to create chart in Power BI and what calculations you take in Power BI.


Status changed to: Needs Info
Regular Visitor

Well Try This,


just change the count(Distinct) to count

Values Different.PNG