How to create hierarchy in Power BI Maps

[Manikanth]

I am working on data with states and cities. I want to create a hierarchy like if i click on a particular state i need to go to the city in that state. Is it possible to overcome my problem by creating hierarchy? Can anyone please help me out on this.

Thanks in advance

[v-qiuyu-msft · Accepted solution]

Hi @Manikanth,

In your scenario, you can create a map visual, then place both State and City fields in Location property, drag a field to Size property. You can turn on drill down, click on any data point, it will drill down to the cities under corresponding state.

Best Regards,
Qiuyun Yu

[davidfabregas]

Qiuyun,

In my case the "city" information is determined by Longitude and Latitude, and the "state" information is just the selection of some of these ones, so it is just a name. It is possible to drill up and down this information on a map? So that the "state" information sums the values of all these "city" and places the information on the map on the median point of these Longitude and latitude values? Or providing a Longitude and Latitude information of the "state"

Thank you in advance.

[Manikanth]

Hi Qiuyun Yu,

Thank you very much for the help. Your solution solved my problem 🙂