cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cwayne758 Member
Member

Incorrect map location

Hello,

 

The Map visual seems to be plotting some of my locations incorrectly (see attached).

 

 

Example of data; Florida, United States, 32217

 

mismap.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
asocorro Member
Member

Re: Incorrect map location

@cwayne758 It seems the state is confusing the mapping.  Look at how I got it to work:

 

2016-02-18_16-03-49.jpg

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
12 REPLIES 12
Phil_Seamark Super Contributor
Super Contributor

Re: Incorrect map location

What data category have you selected for that column?  The map will behave differently if you specify the column to be a City or County etc.  Can you try a few different Data Categories with the map?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

jschwabish Frequent Visitor
Frequent Visitor

Re: Incorrect map location

I'm having a similar problem for city names. It's putting Las Vegas in Spain, not Nevada.

asocorro Member
Member

Re: Incorrect map location

Try to provide more info in the column.  For example, "Las Vegas, Nevada" or "Las Vegas, Nevada, USA".  And categorize the column as City.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
asocorro Member
Member

Re: Incorrect map location

@cwayne758 It seems the state is confusing the mapping.  Look at how I got it to work:

 

2016-02-18_16-03-49.jpg

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
rfway Regular Visitor
Regular Visitor

Re: Incorrect map location

do you add "U.S.A." to zip code for clarification purposes?  What data category do you use for zip, and/or zip, country?

 

thanks in advance.

jordanlevine Frequent Visitor
Frequent Visitor

Re: Incorrect map location

Same deal for me. It worked great for everything except Lake County, California. It keeps putting Lake County in Illinois. I did as the mod suggested and made a new column that was county, state and assigned that the Data Category of County and then it worked.

jordanlevine Frequent Visitor
Frequent Visitor

Re: Incorrect map location

Same deal for me. Kept putting Lake County California into Illinois. I made a new column like the MOD suggested that was county, state and assigned it the data category of County and then it worked fine.

tstinson New Member
New Member

Re: Incorrect map location

I used zipcode and I'm getting a city in France showing up in Cali Smiley Sad

caseyh Member
Member

Re: Incorrect map location

This usually works for me:

 

Create a new calculated column that concatenates the street address, city, state/province, postal code, and country. It seems to geocode faster this way as well:

 

ShipToLocation = 'Details'[Ship To Address] & " " & 'Details'[Ship To City] & " " & 'Details'[Ship To Region] & " " & 'Details '[Ship To Postal Code] & " " & 'Details'[Ship To Country]

 

Instead of placing multiple location-related fields in the location well for the Map visual, just put this one new field in there. This full location can be used with the ArcGis map visual.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 414 members 3,917 guests
Please welcome our newest community members: