Map Visualization Will Not Accept Latitude and Longitude

[nickelcap]

Hi Everyone,

I've set up a large volume of GPS latitude and longitude values that coincide with time stamps and an RPM value in a table, which I thought could be used in Power BI Desktop to create an interactive map.  However, when I try to make the visualization in Power BI Desktop I get the following: Report Pane. When I cursor over the yellow alert icon I get the message: "Location is required to create a map. Click to learn more." Which, when clicked through, does not provide much helpful information.

So far I realized that I needed to set the Long and Lat columns data categories to the correct type, so I've done that. I thought that maybe I had duplicate Long and Lat values so I brought the table back into Excel, removed duplicates from both columns (which really reduced the number of data points, unfortunately).

Any ideas? What am I doing wrong?

Thanks, 

Dan

[Greg_Deckler · Accepted solution]

Drag your timestamp field or create some sort of text field and drag it into Location

[fitnesspowerbi]

As of today it appears that they have fixed the issue with latitude and longitude, you should be able to use them without having to make a calulcated column to concatenate them.

[Sean · Accepted solution]

Create a New Column => Location = [LATITUDE]&","&[LONGITUDE]

Then place Location column in the Location field and remove Lat and Long.

If you add a Legend you'll need Values too which you have.

That's how I get around this issue... Maybe there's another way too...

[nairisha]

This solution worked for me. Thank you.

[Greg_Deckler · Accepted solution]

Drag your timestamp field or create some sort of text field and drag it into Location

[nickelcap]

Worked like a charm, thanks.