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

Change part of a cell

I am pretty new to this world so be easy on me!

Trying to add some GPS coordinates to a desktop report, however the way the numbers come out of a different system is like this

47.40.260N006.62.900W

Is there any way to make this more BI friendly and get it to work on the maps? 

 

Thanks in advance

James

4 REPLIES 4
Microsoft
Microsoft

Hi @JamesSimison ,

 

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.


Best Regards,
Eyelyn Qin

Microsoft
Microsoft

Hi @JamesSimison ,

 

As @themistoklis said, Map visual currently only supports latitude and longitude. But this is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback -https://ideas.powerbi.com/ideas/idea/?ideaid=c1023834-9787-4092-9e1b-8c3e8ed04e50

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Eyelyn Qin

Super User II
Super User II

hello @JamesSimison 

 

I think the example that you have in your message is not correct.

 

If PowerBI doesnt recognise North, East, West South format then it is best to convert them to Lat/Long.

 

For batch conversion you use a free online tool. Good websites are the following:

https://www.doogal.co.uk/BatchReverseGeocoding.php    (Output should be latidtude/longtitude)

https://gridreferencefinder.com/batchConvert/batchConvert.php

 

Then save them in a text file and add them to PowerBI

Cheers, I'll give that a go. the output didn't quite copy over properly, it comes from another system into an excel file with one cell for the lat and one for the long as decimal degrees 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors