Forum Discussion
Post ProdigyScientific notations
Hi All,
I am getting scientific notations in my bar chart. How to remove this values and show the actual numbers?
Hi prakash11440278 ,
Update:
Have created an internal work item: Provide a way to disable scientific notation for values between -0.000001 and 0.000001".
As a workaround, user can use a calculated column/measure to round values between -0.000001 and 0.000001 to zero, then the automatic exponential notation format should not take place anymore.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Please check the data format is decimal, not scientific
Check this solution
https://community.powerbi.com/t5/Desktop/Scientific-Notation-read-as-text/m-p/377891
And keep eye on another open ticket: https://community.powerbi.com/t5/Desktop/Format-measure-incorrect-in-column-chart/m-p/1711007#M677594
v-yingjlCommunity Support
Hi prakash11440278 ,
You can change the format to decimal number and adjust the decimal point to show the correct value but currently there is some issues about negative numbers which could not show the result.
Have sumbitted this issue internal: ICM: 231504209
I will update here as soon as possible if there is any progress.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- v-yingjl
Hi prakash11440278 ,
Update:
Have created an internal work item: Provide a way to disable scientific notation for values between -0.000001 and 0.000001".
As a workaround, user can use a calculated column/measure to round values between -0.000001 and 0.000001 to zero, then the automatic exponential notation format should not take place anymore.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
