cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ChrisH Regular Visitor
Regular Visitor

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 it gives an error saying it can't convert. Any idea why?

 

Many thanks

 

Regards

Chris

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Converting Longitude to Decimal data type

Hey,

 

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

image.png

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
3 REPLIES 3
Community Support Team
Community Support Team

Re: Converting Longitude to Decimal data type

Hi @ChrisH ,

By my tests, I cannot reproduce your issue.

Capture.PNG

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChrisH Regular Visitor
Regular Visitor

Re: Converting Longitude to Decimal data type

Hi 

 

Got this sorted by changing regional settings in PB for decimals

Super User
Super User

Re: Converting Longitude to Decimal data type

Hey,

 

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

image.png

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 28 members 887 guests
Please welcome our newest community members: