Forum Discussion
How to remove Scientific Notation
Hi Anonymous ,
If your problem still persist, you can refer the solution in the following blog to fix it by customizing the display format of the related column or measure to #.###########; 0; #.########### in the model view as shown below.
Getting rid of scientific format for decimal numbers in Power BI
And please change the data type to Decimal, and set decimal places to special number as below screenshot.
Remove Scientific notation in measure
Best Regards
amitchandak sir have changed to Decimal but its still in Scientific .should i change to Excel also ?
Super UserAnonymous , if this coming as Scientific from source, you can open and check power query, then better to change at the source. else you can try to change to decimal in power query too
amitchandak thank you sir your support .let me check
Hi Anonymous ,
If your problem still persist, you can refer the solution in the following blog to fix it by customizing the display format of the related column or measure to #.###########; 0; #.########### in the model view as shown below.
Getting rid of scientific format for decimal numbers in Power BI
And please change the data type to Decimal, and set decimal places to special number as below screenshot.
Remove Scientific notation in measure
Best Regards
Anonymous any way you use this solution and can keep the thousand seperators?
