How to remove scientific notation in Power BI

[Analitika]

Hi,

I have  a case where I have visual which contins values with scientific notation. I rounded to whole number but still see scientific notation, how I could solve this, I expected to see 0 instead of 2e-6.?

[Ahmedx]

also try this:

Measure=FORMAT([Measure],"#,0.0;-#,0.0;0")

[Analitika]

I am getting as text instead int.

[Thennarasu_R]

Hi @Analitika 
once you got the ouput text using Format Function.

And then,

you can convert into interger
 using CONVERT Dax Function

CONVERT([Measure name],INTEGER)

Thanks,
Thennarasu

[Ahmedx]

I'm not sure, but try rounding

[Thennarasu_R]

Hi @Analitika 

You could use this measure,

Measure=Format([Measure],"General number')


Thanks ,
Thennarasu

[ribisht17]

@Analitika 

Please check https://community.powerbi.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986

Regards,

Ritesh

[Analitika]

Nope, didn't help.