Forum Discussion

NickOIT's avatar
NickOIT
New Member
8 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 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.

Need Help
  • Chihiro's avatar
    Chihiro
    8 years ago

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

     

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

2 Replies

  • Chihiro's avatar
    Chihiro
    Icon for Solution Sage rankSolution Sage
    8 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
      8 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!