Forum Discussion

Icon for Post Prodigy rank

Post Prodigy

3 years ago

How to remove scientific notation in Power BI

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.?

7 Replies

ribisht17
Super User
3 years ago
Analitika

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

Regards,

Ritesh
- Analitika
  Post Prodigy
  3 years ago
  Nope, didn't help.
Thennarasu_R
Responsive Resident
3 years ago
Hi Analitika

You could use this measure,

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

Thanks ,
Thennarasu
Ahmedx
Super User
3 years ago
I'm not sure, but try rounding
Ahmedx
Super User
3 years ago
also try this:

Measure=FORMAT([Measure],"#,0.0;-#,0.0;0")
- Analitika
  Post Prodigy
  3 years ago
  I am getting as text instead int.
  - Thennarasu_R
    Responsive Resident
    3 years ago
    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

Related content