Forum Discussion
Post ProdigyFormat measure incorrect in column chart
Hi,
I have a measure which the formula is a DIV( x / y ), and put the formattting to be decimal with number of 2.
But strangely, when I put in column chart, it stay as many decimal ->
The Y-axis setting is Auto :
Also the data labels is Auto:
Anyone experienced like this ?
Thanks,
5 Replies
- amitchandak
Super User
admin_xlsior , check if one of the measure/column X/Y is having scientific format, if so convert to decimal
admin_xlsiorHi Amit,
Nope, all is either "Whole number" or "Decimal". I have checked all the related measures until the field.
Thanks,
- amitchandak
admin_xlsior ,Check this solution :
https://community.powerbi.com/t5/Desktop/Scientific-Notation-read-as-text/m-p/377891
One more user is reporting an issue, keep an eye - https://community.powerbi.com/t5/Desktop/Scientific-notations/m-p/1711141#M677641
Hiadmin_xlsior，
It's pleasant if your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.
Hope it helps.
Best Regards,
Caitlyn YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
