How to change numbers formated as xE-xx`?

[ovonel]

I have some values displayed as:

Where is this format coming from??

The values are from a measure that is doing

CALCULATE (

    SUM ( ‘Table’[Actual] ),

  'Filter’[Level2]="Xyz"

)

And the column actual is:

How can I prevent this to display 6E-12 I would rather see 0.

[v-yetao1-msft · Accepted solution]

Hi @ovonel 

We usually call the “-1E -14” decimal format . To fix this to show the team’s targets as decimals and not converted to scientific format is to customize the display format of this column or measure to 0.##################;0;0.################## in the model view as shown below. That works the magic ! You can have a try .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ovonel , Use number of decimal place as 1 or 2 and try