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?
Thank you
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:
Steps
In Excel file, make sure that the column format is "Number".
"Number"
In Power BI desktop, open "Query Editor" by clicking on the "Edit Queries".
"Query Editor"
"Edit Queries"
in the Transform tab, click on the "Detect Data Type" button.
Transform
"Detect Data Type"
Make sure that the "Data Type" is set to "Decimal Number".
"Data Type"
"Decimal Number"
Fields
Modeling
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.
1.1k questions
678 answers
456 comments
193k users
Related Activities
Categories
Most popular tags