scientific notation for 0 on bar chart

[akos_skutovics]

 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.

[Ashish_Mathur]

Hi,

Try this

Measure 2 = coalesce([measure 1],0)

Hope this helps.

[v-angzheng-msft · Accepted solution]

Hi, @akos_skutovics 

Have sumbitted this issue internal: ICM: 231504209

Have 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/2281689

https://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_skutovics]

I noticed rounding the value in the measures solves this visual issue but I still find it interesting that without rounding, it showed 1E-9