Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Converting Longitude to Decimal data type

Hi there   I am importing some longitude and latitude values from a text file. I need to store these as numbers.   So my one longitude value is -2.511761 When I try to convert it to a decimal i...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    check the "Regional Settings" of the current Power BI file:

    It's likely, that your seetings do not match the character that is used in your text file.

     

    Hopefully this provides some additional insights.

     

    Regards,

    Tom

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

By my tests, I cannot reproduce your issue.

Please check if all of the values for longitude is like -2.511761.

If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi 

     

    Got this sorted by changing regional settings in PB for decimals