How to create a drill down map and have the map bubble showing the total values

[Anonymous]

Hi, i am working on a project that is able to show the numbers of hotel in Asia Pacific by location and the map bubble is able to show how many hotels are in each country or region.

enable me to drill down to each country down to each state to location the exact Hotel location.  

please advise

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

If I understand your requirement correctly that you want to create a map visual to show the number of hotels in each country or region.

If it is, you could create a hierarchy with country and region and drag it into Location field, then drag the count of  hotels column to Size field.

If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.

Best  Regards,

Cherry