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: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

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
Anonymous
Not applicable
‎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

Anonymous
Not applicable
‎03-11-2019 08:17 PM
 
Anonymous
Not applicable
‎03-11-2019 08:24 PM

Well Try This,

 

just change the count(Distinct) to count

Values Different.PNG

Idea Statuses