Format measure incorrect in column chart

[admin_xlsior]

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,

[Anonymous]

Hi@admin_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 Yan

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

[amitchandak]

@admin_xlsior , check if one of the measure/column  X/Y is having scientific format, if so convert to decimal

[admin_xlsior]

Hi 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.