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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |