Forum Discussion

Vinyboy143's avatar
Vinyboy143
New Member
1 year ago
Solved

Scientific number format change

Hello All, I'm unable to change this listed value to ##.## and in the Ppower BI report in single score it shows a Scientific Value. Please help me a way to change it.
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Vinyboy143 

    Power BI Desktop currently have rules to use scientific notation with E when the value is too small (<0.0001) or too large.


    One way to prevent this may be to change the number type to currency format, which will prevent scientific notation from being applied.

     

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Have you recently installed 2.135 ?

Vinyboy143's avatar
Vinyboy143
New Member
1 year ago

Yes, I've installed and have the latest version of power bi desktop 

  •  
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    I have seen similar issues with our users where all of a sudden Power BI desktop now uses the Windows "Web pages and apps" locale.  Check that on your PC, and if you can, revert back to the August version.