Forum Discussion
Difference in excel data and power bi data
Hi Team,
I have taken a sample database "Superstore" tried to import via power bi and have a table visualisation for sales and year as below
im not sure what is wrong i tired checking the Sales column datatype everything seems normal.
Can you all please provide me any suggestion what could go wrong
Anonymous Total will be same. But values under year is different due to using incorrect date field.
6 Replies
- negi007
Community Champion
Anonymous can you pl share your excel data file. it is possible that date field and data field from different tables are being used in excel and powerbi report. Once you share data then will assist you.
negi007this is the link from where i downloaded the excel report name (Sample - Superstore Sales (Excel) for Tableau 8.x versions) https://www.wisdomaxis.com/technology/software/data/for-reports/super-stores-data-for-reports.php
Im not sure how do i upload the pbix in this community.can you help on that as well:-)
- negi007
Anonymous
It is workly prefectly fine for me.
Below is powerbi Screenshot
- amitchandak
Super User
Anonymous , Does your date has a timestamp. Are you joining it with date table in power bi if so make sure there is no timestamp
date = [order date].date
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
