Forum Discussion
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.
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.
4 Replies
- lbendlin
Super User
Have you recently installed 2.135 ?
Yes, I've installed and have the latest version of power bi desktop
- lbendlin
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.
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.
