Forum Discussion
scientific notation for 0 on bar chart
- 4 years ago
Hi, akos_skutovics
Have sumbitted this issue internal: ICM: 231504209Have created an internal work item: Provide a way to disable scientific notation for values between -0.000001 and 0.000001".
As a workaround, user can use a calculated column/measure to round values between -0.000001 and 0.000001 to zero, then the automatic exponential notation format should not take place anymore.
And 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
Refer:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-remove-Scientific-Notation/m-p/2281689https://community.powerbi.com/t5/Desktop/Scientific-notations/m-p/1711141
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Try this
Measure 2 = coalesce([measure 1],0)
Hope this helps.