Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Map with specific countries and continents

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: 

GeographyEntry
Japan1
Europe1
North America1
Hong Kong0
Australia1
West Africa1


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

Need Help
Tips and Tricks

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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.