Forum Discussion
Helper Iscientific notation for 0 on bar chart
have an issue where 0 shows as 1E-9 on both card visual and bar chart, however not in a table. What am I missing?
measure format
data column format:
data type in the dataflow is a decimal number with 2 decimal digits.
when the format is changed to a decimual number with 2 decimal digits, the measure shows 1E-11 instead of 1E-9
I have tried to change the format many different ways but that did not make a change. Also adding 0, 0.0, or multiplying the measure made no difference either.
Interesting that when the filter is applied in the table (by clicking on that row), then the data shows as 0.
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.
3 Replies
- v-angzheng-msft
Community Support
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. 
akos_skutovicsI noticed rounding the value in the measures solves this visual issue but I still find it interesting that without rounding, it showed 1E-9
- Ashish_Mathur
Super User
Hi,
Try this
Measure 2 = coalesce([measure 1],0)
Hope this helps.
