Combine countries for mapping

[ezequiel]

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

[Sean · Accepted solution]

@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

[ezequiel]

Thanks all. It worked!

[Greg_Deckler]

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.