Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Submitted by Anonymous on ‎03-11-2019 03:47 PM

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

Untitled.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yuezhe-msft
Employee
Employee
‎03-11-2019 08:17 PM

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

Regards,
Lydia

v-yuezhe-msft
Employee
Employee
‎03-11-2019 08:17 PM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎03-11-2019 08:24 PM

Well Try This,

 

just change the count(Distinct) to count

Values Different.PNG

Idea Statuses