cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AClerk New Contributor
New Contributor

Map showing wrong location

Hey All,

I have a map visualisation that shows wrong places.

Examples are in screen shots below.

What can I do about it?

Some points, however, show in the correct place.


2019-08-27 10_48_44-papercut - Remote Desktop Connection.png2019-08-27 10_47_34-papercut - Remote Desktop Connection.png

 

Cheers!
A

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
AClerk New Contributor
New Contributor

Re: Map showing wrong location

Hi @v-juanli-msft 

I have done that already. Tried a few categories, that is why it is not showing correctly in the screenshot.

Anyhow,I found the root cause.

I have duplicates on the location name --> Same location name but in a different state. So the map is showing an average lat/long for all places with the same name.

The solution:

I have created a custom column that will concatenate the (Location, State, Country). That resolved my problem.

_1.png

 

Cheers!
A

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Map showing wrong location

Hi @AClerk 

It seems the location is confusing the mapping.

The map will behave differently if you specify the column to be a City or County etc.

Please change the "Data category" to the correct format: city, state, or something else.

https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AClerk New Contributor
New Contributor

Re: Map showing wrong location

Hey @v-juanli-msft 

Thanks for your reply.

I am using Latitude and Longitude and not city/state/country names.

For example Longrech
In bing maps shows the correct location.

The values I have in my dataset is -34.87, 150.524 as you can see in the screenshot below for bing.

2019-08-29 14_32_42-Window.png

However, in PBI the numbers are different.

2019-08-29 14_35_04-Window.png

 

And my settings

2019-08-29 14_38_56-Window.png

 

Cheers!
A

Community Support Team
Community Support Team

Re: Map showing wrong location

Hi @AClerk 

In Modeling->Data category

change columns "Latitude" and "Longitude" to  "Latitude" and "Longitude" type.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
AClerk New Contributor
New Contributor

Re: Map showing wrong location

Hi @v-juanli-msft 

I have done that already. Tried a few categories, that is why it is not showing correctly in the screenshot.

Anyhow,I found the root cause.

I have duplicates on the location name --> Same location name but in a different state. So the map is showing an average lat/long for all places with the same name.

The solution:

I have created a custom column that will concatenate the (Location, State, Country). That resolved my problem.

_1.png

 

Cheers!
A

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 244 members 2,740 guests
Please welcome our newest community members: