Forum Discussion

MichKo's avatar
MichKo
New Member
1 year ago
Solved

Shape Map Multiple Filters?

Hello everyone, I am new to Power-Bi and would like to create a world map with shape maps (no, the other variants are unfortunately not an option). A simple world map that visualises a parameter (e...
Need Help
Tutorial Requests
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi MichKo - You’ll need to structure your data appropriately. Please find the attache pbix file FYR: It has involved with other countries too, so suggest to use Map visual instead of shape map.

     

    If you want to filter by region, create a new calculated column in the data to assign regions to countries:

    Region =
    SWITCH(
    TRUE(),
    'Table'[Country] IN {"Germany", "France", "Italy"}, "Europe",
    'Table'[Country] IN {"Australia", "New Zealand"}, "Oceania",
    'Table'[Country] IN {"United States", "Canada"}, "North America",
    "Other"
    )

     

    Hope this helps. 

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi MichKo - You’ll need to structure your data appropriately. Please find the attache pbix file FYR: It has involved with other countries too, so suggest to use Map visual instead of shape map.

 

If you want to filter by region, create a new calculated column in the data to assign regions to countries:

Region =
SWITCH(
TRUE(),
'Table'[Country] IN {"Germany", "France", "Italy"}, "Europe",
'Table'[Country] IN {"Australia", "New Zealand"}, "Oceania",
'Table'[Country] IN {"United States", "Canada"}, "North America",
"Other"
)

 

Hope this helps.