Forum Discussion

prashpokala's avatar
prashpokala
Regular Visitor
6 years ago
Solved

ArcGIS maps with multiple data sets

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...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    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's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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.⚡