Forum Discussion
admin_xlsior
Post Prodigy
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 -> ...
amitchandak
Super User
Super Useradmin_xlsior , check if one of the measure/column X/Y is having scientific format, if so convert to decimal
admin_xlsiorPost Prodigy
Post ProdigyHi 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
- admin_xlsior
I see..
Ok, guess it is some kind of bug then. Too bad the solution suggested I bet will not working in my environment because it is using Direct Query. They want allow us to change data type
Thanks.