Forum Discussion
How to create hierarchy in Power BI Maps
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
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
3 Replies
v-qiuyu-msftCommunity Support
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 YuHi Qiuyun Yu,
Thank you very much for the help. Your solution solved my problem :)
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.
