Forum Discussion

NickOIT's avatar
NickOIT
New Member
7 years ago
Solved

Changing Data Type to Decimal Number, Removes Decimal Point

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 a...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

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

     

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

Chihiro's avatar
Chihiro
Solution Sage
7 years ago

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

 

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

  • NickOIT's avatar
    NickOIT
    New Member
    7 years ago

    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!