Forum Discussion
Solved
Prevent Scientific Notation
I'm dealing with some ID numbers that show up fine in Excel but get converted to Scientific Notation whenever I import them in PBI, which also changes the numbers for some reason. Is there any way to...
Just started working actually, I added a * to the column in excel and then removed it in PBI!
We have a similar problem. Some zeros in Tables and Matrices appear with scientific notation, dispite being set to Integer.
We solved it by rounding to two decimals with ROUND([measure], 2), and then changing the format to 'Whole number' in the Modelling tab.
please try the solution in the article here:
https://pivotronics.com/2021/06/29/getting-rid-of-scientific-format-for-decimal-numbers-in-power-bi/