Forum Discussion
Prevent Scientific Notation
Just started working actually, I added a * to the column in excel and then removed it in PBI!
I'd like to play around with that, how big does the number have to be in Excel?
Just started working actually, I added a * to the column in excel and then removed it in PBI!
Glad to hear that you've solved this problem. You could help accept it as solution. Your contribution is highly appreciated.
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/
