Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all.
My data set in Excel shows the total sales for the years 2013 - 2020 to be 6,107,910 but PBI is showing me 6,107,925.
What I did, to double-check, I basically just uploaded to PBI a mock of my original data set with only total sales for 2013 - 2020 years and nothing else, and the error keeps showing... Please, help!
Solved! Go to Solution.
Hey @Anonymous ,
Click on Transform Data
Then Select the amount column ->right Click -> Change data type -> Decimal Number
This is your Row card with correct output:
If your problem is solved then accept this as solution
Thank you
Hey @Anonymous ,
Can you share the sample data and the pbix file?
and the Dax formula which you used for calculating the total sales.
Thank you.
PBIX
SOURCE
I mean is literally just the amounts, why it can't show the right total? Thanks
Hey @Anonymous ,
Click on Transform Data
Then Select the amount column ->right Click -> Change data type -> Decimal Number
This is your Row card with correct output:
If your problem is solved then accept this as solution
Thank you
@Anonymous
You need to change the Data Type to Decimal or Fixed Decimal, currently its Whole number in order to match with your Excel file.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The data type of the `AMOUNT` column is set to "Whole Number" in the Power Query editor. Switch it "Decimal Number" and PBI will show "...910" too.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |