Changing Data Type to Decimal Number, Removes Decimal Point

[NickOIT]

Hi,

I'm having an issue where I have a column with decimal numbers that aren't being detected by Power BI and when I try to manually change the data type to either of the decimal options (fixed and non fixed), the decimal is removed and the number is now a whole number.

Here's an example::

Before

After

Anybody got any ideas on how I can proceed?

Thanks for any help.

[Chihiro · Accepted solution]

Hmm, do you happen to have Regional setting where comma "," is used as decimal separator?

If so, try replacing "." with "," before conversion.

[NickOIT]

Haha!

That fixed it!

Well, I guess it shows that I'm an expat. Would never even have considered that.

Thanks so much for your help Chihiro!