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 "Ar...
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

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.