ArcGIS maps with multiple data sets

[prashpokala]

Hi. I have 3 datasets (our company's manufacturing plants, competitors plants and customers locations) in 3 different files. I want to display all the 3 on a map with different colors. I cannot merge / join all the files into the same file, as the columns are different for each file other than the lat / long and address fields. I also want to be able to filter on the customer locations, while keeping the other locations in tact. Is there a way I can do that? 

Thanks for any help!!

[Whibley92]

Hi, I'm trying to map 2 sets of postcodes - one showing stores and one showing hotels.

Do I have to add the Custom column in PowerBI and appeand or can I add it in the main spreadsheet and then use the name for each set to label? I am struggling a bit with setting up a legend. Very new to ArcGIS.

Thanks 🙂

[pacifist]

Sorry to revive this topic...

The above solution is ok, but what if you have one dataset represented as points, and one a polygons (polylines), e.g. voting areas... There is no way of combining the data into a single "layer". The limitation of a single dataset is one of the biggest drawbacks of this visual

[v-zhenbw-msft · Accepted solution]

Hi @prashpokala ,

We can create a same column in each table and append them as new table to meet your requirement.

1. Create a same name column in each table.

2. Then we can append the tables as new.

3. Then we can put the custom column in legend to distinguish each dataset.

If you have any question, please kindly ask here and we will try to resolve it.

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@prashpokala yes it can be done, you have two options:

- append all tables together (which seems to be ruled out) and in this append, you have a tag for each data source that you can use on Legend to show different colors on the map

- 2nd option is to create dimension for common columns and link to 3 tables you have, kind of dimension and facts, and use common fields from dimension and values from facts. 

Above are very common scenarios and can be easily achieved with proper data modeling.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡