Map with specific countries and continents

[Anonymous]

Hi, is there a way to create a map that displays geographical data at continent level as well as specific countries and regions?

For example using the dummy data: 

Geography	Entry
Japan	1
Europe	1
North America	1
Hong Kong	0
Australia	1
West Africa	1

Basically, I would like to use a map to display the %count of entry instead of a stacked bar. How can I achieve this?

Update:

East Africa is the one I have a problem with as it appears on the map to be Central Africa.

Thanks

[Anonymous]

Hi @Anonymous 

I think you can build a hierachy(continents and countries ) in your data model.

My Sample:

Create a measure to calcualte the percentage of the count.

Percentage of Entry for each Continent =
VAR _Sum =
    SUM ( 'Sample'[Entry] )
VAR _Total =
    SUMX (
        FILTER ( ALL ( 'Sample' ), 'Sample'[Continent] = MAX ( 'Sample'[Continent] ) ),
        'Sample'[Entry]
    )
RETURN
    DIVIDE ( _Sum, _Total )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I reckon this a good approach.

Just for clarification, suppose that the original data has broader classification like 'East Africa', how can I handle that using this method?

As mentioned in the original post, my problem was East Africa dispaying on the central part of Africa on the map.

[amitchandak]

@Anonymous , I think shape map help you for custom region

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

[Anonymous]

Thanks. I had a look and I unfortunately don't think this helps with my problem.