Forum Discussion
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
Good Luck! :smileyhappy:
Post some sample data of all columns involved in both data sets
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_City | Primary_State | postal_code |
| Blumenort | MB | R0A 0C0 |
| Kleefeld | MB | R0A 0V0 |
| Landmark | MB | R0A 0X0 |
| New Bothwell | MB | R0A 1C0 |
| St Laurent | MB | R0C 2S0 |
| Teulon | MB | R0C 3B0 |
| Warren | MB | R0C 3E0 |
| Beausejour | MB | R0E 0C0 |
| Carman | MB | R0G 0J0 |
| Manitou | MB | R0G 1G0 |
| St Claude | MB | R0G 1Z0 |
| Sanford | MB | R0G 2J0 |
| Neepawa | MB | R0J 1H0 |
| Sandy Lake | MB | R0J 1X0 |
| Baldur | MB | R0K 0B0 |
| Brookdale | MB | R0K 0G0 |
| Cartwright | MB | R0K 0L0 |
| Killarney | MB | R0K 1G0 |
| Souris | MB | R0K 2C0 |
| Roblin | MB | R0L 1P0 |
My second table has "supply locations" which has different set of postal codes..
| Primary_City | Primary_State | postal_code |
| Brandon | MB | R7A 7M5 |
| Neepawa | MB | R0J 1H0 |
| Winnipeg | MB | R2J 0T9 |
| Blumenort | MB | R0A 0C0 |
| Neepawa | MB | R0J 1H0 |
| Winnipeg | MB | R2J 3V9 |
| Winnipeg | MB | R2J 3V9 |
| Teulon | MB | R0C 3B0 |
| Winnipeg | MB | R2J 0S3 |
| Winnipeg | MB | R2W 2Z3 |
| Winkler | MB | R6W 4A8 |
| Winnipeg | MB | R3Y 1G6 |
| St Laurent | MB | R0C 2S0 |
| Souris | MB | R0K 2C0 |
| Winnipeg | MB | R2X 1G4 |
| Springfield | MB | R2C 2Z2 |
| Winnipeg | MB | R2C 4G5 |
| Winnipeg | MB | R2J 3S1 |
| Blumenort | MB | R0A 0C0 |
| Beausejour | MB | R0E 0C0 |
| Portage La Prairie | MB | R1N 3B2 |
| Winnipeg | MB | R2L 0X5 |
| Winnipeg | MB | R3E 2V2 |
| Swan River | MB | R0L 1Z0 |
| New Bothwell | MB | R0A 1C0 |
| Warren | MB | R0C 3E0 |
| Melita | MB | R0M 1L0 |
| Schanzenfeld | MB | R6W 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"