Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ezequiel
Employee
Employee

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

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@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

Map.png

View solution in original post

3 REPLIES 3
Sean
Community Champion
Community Champion

@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

Map.png

Thanks all. It worked!

Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.