cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Sean
Community Champion
Community Champion

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
samsonobolade
Frequent Visitor

Hi, I've got a similar issue but I want the distance in figure and not to plot it on the map.

 

For example I want to know which of my cutomer travelled the longest distance to me.e.g 4miles, 7miles et.c

Sean
Community Champion
Community Champion

@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

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

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

stuross
Frequent Visitor

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

@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

sshekar7
Frequent Visitor

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?

Sean
Community Champion
Community Champion

@sshekar7

The Column that is the Location Field - includes all Locations

Therefore you can either create a

1) SLICER (same as below - select all and uncheck the ones you don't want)

OR

2) Go to the Visual Level Filters - open the Location Field Column - Basic Filtering - Select All - Uncheck only the ones you don't want

 

There are other ways too by creating additional conditional column to Include and Exclude...

 

But option 2 is probably the fastest/easiest way to do this! Smiley Happy

 

Map Locations - 2 Datasets - 3.png

stuross
Frequent Visitor

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

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

Anonymous
Not applicable

Hello! Can you provide a step by step process on how to do this? I can't seem to be able to do this

Anonymous
Not applicable

Hi Sean,

 

I have 3 type of location: buyer, supplier, and report, so I have samiliar approach with Type as slicer.

But when a city has multiple types of location, it shows as pie chart. Instead of pie chart, we just want overlap in the same location, how can I achieve that?

Thanks!Capture.PNG

Thanks for the reply ,Fenglar. I believe what I am looking for is to calculate distance between 2 log and latitude rather than showing this points on a map. I want result like 4Miles to seller, 3 miles etc. I hope this is clearer now.@flengar

how do you do an overlay? Thanks!

sshekar7
Frequent Visitor

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"

Helpful resources

Announcements
T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors