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

Map multiple data sets on the same map

I have 2 datasets:

 

Dataset 1 has a latitude and longitude value for every piece of equipment my company has working in remote locations.

Latitude

Longitude

EquipmentID

 

Dataset 2 has a latitiude and longitude value for every possible remote location that my company could be working, but does not currently have equipment.  These locations would identify potential customers.

Latitude

Longitude

LocationID

CompanyName

 

On the same map I want to plot the locations where I am currently working, and also plot the locations where potential customers could be so I can see them together.

 

How could I accomplish this?

1 ACCEPTED SOLUTION

Accepted Solutions
Sean Community Champion
Community Champion

Re: Map multiple data sets on the same map

Yes do overlay here too!

That's why in the picture on the right those locations are neither red nor green because they are directly on top of each other!

And yes you can use a slicer(s) to turn on/off various elements such as Current or Prospect

 

Map Locations - 2 Datasets - 2.png

 

Good Luck! Smiley Happy

View solution in original post

15 REPLIES 15
Sean Community Champion
Community Champion

Re: Map multiple data sets on the same map

@stuross

Merge the 2 datasets in the Query Editor (you can keep only the relevant columns)

Post some sample data...

You can create a conditional column say - if no EquipmentID - "prospect" else "current" so you can use this as a Legend

to easily identify current vs prospects...

its tough to say what the best option would be without seeing some sample data of the 2 datasets Smiley Happy

sshekar7
Frequent Visitor

Re: Map multiple data sets on the same map

Sean,

 

I have similar situation.. the two datasets cannot be merged since they dont have same zipcodes for example.. so if i want to map two datasets containing different sets of zipcodes then how do i do this? 

 

If i append both datasets into one then i can see all zipcodes but i want ability to filter zipcodes from first dataset and always see zipcodes from second dataset.

Sean Community Champion
Community Champion

Re: Map multiple data sets on the same map

Post some sample data of all columns involved in both data sets

sshekar7
Frequent Visitor

Re: Map multiple data sets on the same map

ok.. i dont see an option to upload an excel file here so i am pasting tables here itself..  

 

Here is "my locations" table which i would like to see on map.. its canadian... thats straight forward when i use postal code as location.

 

 

Primary_CityPrimary_Statepostal_code
BlumenortMBR0A 0C0
KleefeldMBR0A 0V0
LandmarkMBR0A 0X0
New BothwellMBR0A 1C0
St LaurentMBR0C 2S0
TeulonMBR0C 3B0
WarrenMBR0C 3E0
BeausejourMBR0E 0C0
CarmanMBR0G 0J0
ManitouMBR0G 1G0
St ClaudeMBR0G 1Z0
SanfordMBR0G 2J0
NeepawaMBR0J 1H0
Sandy LakeMBR0J 1X0
BaldurMBR0K 0B0
BrookdaleMBR0K 0G0
CartwrightMBR0K 0L0
KillarneyMBR0K 1G0
SourisMBR0K 2C0
RoblinMBR0L 1P0

 

My second table has "supply locations" which has different set of postal codes..

 

Primary_CityPrimary_Statepostal_code
BrandonMBR7A 7M5
NeepawaMBR0J 1H0
WinnipegMBR2J 0T9
BlumenortMBR0A 0C0
NeepawaMBR0J 1H0
WinnipegMBR2J 3V9
WinnipegMBR2J 3V9
TeulonMBR0C 3B0
WinnipegMBR2J 0S3
WinnipegMBR2W 2Z3
WinklerMBR6W 4A8
WinnipegMBR3Y 1G6
St LaurentMBR0C 2S0
SourisMBR0K 2C0
WinnipegMBR2X 1G4
SpringfieldMBR2C 2Z2
WinnipegMBR2C 4G5
WinnipegMBR2J 3S1
BlumenortMBR0A 0C0
BeausejourMBR0E 0C0
Portage La PrairieMBR1N 3B2
WinnipegMBR2L 0X5
WinnipegMBR3E 2V2
Swan RiverMBR0L 1Z0
New BothwellMBR0A 1C0
WarrenMBR0C 3E0
MelitaMBR0M 1L0
SchanzenfeldMBR6W 1K5

 

I would like to always see the "supply locations" in my map.

 

Idea is that by filtering one of "my locations" i need ability to see my "supply locations"

stuross
Frequent Visitor

Re: Map multiple data sets on the same map

Here is a sample from each dataset.

 

Note:  there may be similar lat and long in each set, but this will not always be the case.  So it can't be assumed that this ties the datasets together as there could be situations where lat and long never matches.

 

In a perfect world I could control visiblity of each dataset independent of the other on the map, and quickly see areas where my work is concentrated relative to all areas that have work taking place.  I have used another product that allowed me to select datasets to be visable without the requirement for the datasets being joined.  Hoping this is possible and thanks for your help.

 

 

Data Set 1

MXXEquipmentIDLatitudeLongitudeLocationName
245654.51225-118.62191KAKWA 11-1-64-5
789654.46818-118.60062102 KAKWA 11-19-63-4
1333654.4303-118.52172DD ET AL KAKWA 3-10-63-4
1877654.38926-118.64139ET AL 102 KAKWA 6-26-62-5
2421654.39189-118.59343ET AL 102 KAKWA 6-30-62-4
2965654.40489-118.62569ET AL HZ 102 KAKWA 1-36-62-5
3509654.38427-118.63158ET AL HZ 102 KAKWA 16-26-62-5
4053654.39726-118.60073ET AL HZ KAKWA 1-31-62-4
4597654.41491-118.60316ET AL HZ KAKWA 13-36-62-5

 

 

Dataset 2

 

LocationIDLatitudeLongitudeCompanyName
A547854.51225-118.62191Sanders
C514754.46818-118.60062Sanders
A57854.4303-118.52172Mott
A921454.38926-118.64139Mott
N4789554.41679-118.58234Selve
A547954.41692-118.58229Hillier
C514854.40503-118.6257Hillier
A1785054.40951-118.60323Hillier
A2648654.36622-118.50757Selve
N4789654.46785-118.71304Keller
A548054.46785-118.71304Ladd
Sean Community Champion
Community Champion

Re: Map multiple data sets on the same map

@stuross

 

You have Identical Locations (to 5 decimal places) that can be both Prospect and Current

or can be 2 different Prospects at the same exact Location

 

Map Locations - 2 Datasets.png

 

How did you handle these with the other software?

 

EDIT: Oh and I meant - Append the 2 tables (see picture)

Map Locations - 2 Datasets - 0.png

 

Map Locations - 2 Datasets - 00.png

stuross
Frequent Visitor

Re: Map multiple data sets on the same map

Yes, some lat and longs are identical but this can not be guaranteed in my data.

 

This approach may work.  Other software I used was Saleforce with Geopointe add-in for mapping.  For mapping I could add many datasets and not have to merge them in order to display.  I could have many lat longs at exact same location (in different data sets)and it would just visually overlay them, and i could selectively turn an entire data set on or off.

 

I will try your approach as it should work for what I am trying to accomplish.

 

Thanks!!!

Sean Community Champion
Community Champion

Re: Map multiple data sets on the same map

Yes do overlay here too!

That's why in the picture on the right those locations are neither red nor green because they are directly on top of each other!

And yes you can use a slicer(s) to turn on/off various elements such as Current or Prospect

 

Map Locations - 2 Datasets - 2.png

 

Good Luck! Smiley Happy

View solution in original post

sshekar7
Frequent Visitor

Re: Map multiple data sets on the same map

If you want to filter out a specific current prospect and also look at the future prospects around the current prospect then how do u do this?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors