Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Different totals than in data source

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 ...

Ajinkya369
6 years ago
Hey Anonymous ,

Click on Transform DataTransform Data

Then Select the amount column ->right Click -> Change data type -> Decimal Number

Change type

This is your Row card with correct output:

Output
If your problem is solved then accept this as solution

Thank you

Anonymous

Not applicable

6 years ago

PBIX

https://amksavonia-my.sharepoint.com/:u:/g/personal/karen_urbanocuellar_edu_savonia_fi/EWZmIWzrAFpIn2oX62FZGe8ByIwKaPAfXRV_dvnoEEvScw?e=DHtGtk

SOURCE

https://amksavonia-my.sharepoint.com/:x:/g/personal/karen_urbanocuellar_edu_savonia_fi/EcHzZ2L51hBKoOI8LWhYWiABkFplS1pqRJAK_WgQfIe7yA?e=3v5dR8

I mean is literally just the amounts, why it can't show the right total? Thanks

Icon for Super User rank

Super User

6 years ago

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 🙂

YouTube, LinkedIn

Related content