cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kunlemic Frequent Visitor
Frequent Visitor

overlay two different coordinate dataset in one map

Hi, I am working on a report that plot geo coordinate on a map and overly another geo coordinate on the same map. How can I do this on power BI?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: overlay two different coordinate dataset in one map

You can append two datasets into a single one with columns: 

 

lat | long | set

 

where lat and long would be coordinates and set would be a differentiator for your geographical layers. Then simply use Map visual as follows:

 

maplayers.pngSample map with "layers"

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Re: overlay two different coordinate dataset in one map

You can append two datasets into a single one with columns: 

 

lat | long | set

 

where lat and long would be coordinates and set would be a differentiator for your geographical layers. Then simply use Map visual as follows:

 

maplayers.pngSample map with "layers"

View solution in original post

kunlemic Frequent Visitor
Frequent Visitor

Re: overlay two different coordinate dataset in one map

@Anonymous

 

Thanks for the assistance again and it worked just right but I noticed that when I have large data, only one set is showing. Please is there any limitation to the size of data that this principle can work with.

 

Regards,

 

Kunle

Anonymous
Not applicable

Re: overlay two different coordinate dataset in one map

Unfortunately, yes, there is a limit of 3500 points you can display on the map visual at the same time. So you need to use some data filtering to limit the number of points to display. You can vote here if you would like Microsoft to change it: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7394290-allow-more-data-points-to.... Otherwise you would have to create your own custom visual I guess (needs code development).

kunlemic Frequent Visitor
Frequent Visitor

Re: overlay two different coordinate dataset in one map

Thanks a lot. This is very helpful. I just voted and if I may ask, at what point is the filtering applied: before getting data into power bi or after getting the data before I introduded a filter to display point less than 1000 and it still did not work.

 

I am also interested in the personal custom visual, any guide will be helpful.

 

Regards,

 

Kunle

cbouichi Member
Member

Re: overlay two different coordinate dataset in one map

The layout changed since the last update. Is this methode still possible?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)