Shape Map Multiple Filters?

[MichKo]

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.g. the number of my files in the respective country) and grades it according to the value is no problem. The same applies to adding a filter that then filters the corresponding regions (e.g. Europe, Asia, ...).

However, my data set is larger and I'm not sure how to get there or how to organise my data in a meaningful way.

Here is an example:
I have created a sample file (where can I upload it here?).

I have a table in which the number (total) of files are listed for each country as ‘Total Alive’, ‘Alive & Pending’, ‘Alive & Final’, ‘Total Dead’, ‘Dead & Pending’, ‘Dead & Final’.

And then I have another detailed table in which the individual countries for each status are listed for each file.
So File-ID 1: ‘Alive & Pending’ in Australia & Germany, ‘Dead & Final’ in United States
And then for all 100 files that I have.

I would like to be able to filter the world map as follows and copy the filters to each other.
-By region (Europe, Asia, ...)
-By Dead or Alive
-By Pending or Final
-According to the file IDs (i.e. only file no. 1 or 2 or...)

How do I do this?

[rajendraongole1 · Accepted solution]

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.