I have a decimal number in Excel and the format of cell in (number with two-digit decimal) and I want to import that numbers to the power bi but with the same value and without approximated.
Below is the screenshot from Excel
The blow screenshot from power bi, notes the values is changed
So what is the trick to avoided the issue like this in the future?
If you have imported values from a database or excel sheet and the imported decimal values are showing as an integer values instead of decimal. so in this case, you should do the following:
In Excel file, make sure that the column format is "Number".
In Power BI desktop, open "Query Editor" by clicking on the "Edit Queries".
in the Transform tab, click on the "Detect Data Type" button.
"Detect Data Type"
Make sure that the "Data Type" is set to "Decimal Number".
Adjust the decimal places as you prefer.
You might also like to read
In a case like this, We have to check 3 things
After that just refresh the data and everything should be OK.
Most popular tags