Forum Discussion
sum is incorrect
here is a clearer example and comparison between the excel data and PBI data.
As you can see the data in yellow is missing and the ones in green are appearing on PBI.
Please check you have the filter applied anywhere eg. in edit queries or page/report level filter.
if possibel, could you please remove sensitive data columns and share it for us have a test?
Regards,
Lin
- mehdibentorkia6 years agoRegular Visitor
I have no filters or anything. I literarly, just selected table as visualisation and selected sales and service name.
See screenshot:
- v-lili6-msft6 years ago
Community Support
- mehdibentorkia6 years agoRegular Visitor
please copy and paste the link into your browser, not sure why when you click on it, it changes the link.
- v-lili6-msft6 years ago
Community Support
From the screenshot, we could just guess that data is missing or data is filtered. we need more information about it.
since your data is sensitive, i would suggest you submit a support ticket to get further help from power bi support.
https://powerbi.microsoft.com/en-us/support/
Regards,
Lin
- mehdibentorkia6 years agoRegular Visitor
I did not filter anything.
the data is clearly missing but it is on the excel sheet as per the screenshot so why doesn't it appear on power bi.