Forum Discussion

ezequiel's avatar
ezequiel
Microsoft Employee
10 years ago
Solved

Combine countries for mapping

Hi...I'm working on a report that reflects sales. I have regions that combine more than one country, for example Argentina and Uruguay. How can I represent that on a map when the region is called "Argentina & Uruguay"? I'd like to select a value and see the map highlighting those 2 countries.

 

Any idea would be appreciatted it

 

Thanks,

 

Ezequiel

Tutorial Requests
  • Sean's avatar
    Sean
    10 years ago

    ezequiel You can resolve this couple ways...

     

    Either add a Region Column to your Source

    OR

    create a table with just these 2 - Country Column and Region Column and relate it to your Sales table by Country

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Haven't tried this, but potentially you could create a table with your "sales areas" such as:

     

    Sales Area,Country

    Argentina & Uruguay,Argentina

    Argentina & Uruguay,Uruguay

     

    Relate that to your fact table on "Country" column. Then put the "sales area" table's "Sales Area" column in a slicer and you should be able to use that to filter your map visualization.

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    ezequiel You can resolve this couple ways...

     

    Either add a Region Column to your Source

    OR

    create a table with just these 2 - Country Column and Region Column and relate it to your Sales table by Country