drilldown in maps from country to state level

[Anonymous]

hi

i am very much new to use maps in powerbi . i have one of the requirement where i need to drill down from country to state level . Like if i click on USA i need to drill dwon to states . Can anyone let me know how this works  and which visualization we need to work on . Any detail steps on this ?

[v-xicai]

Hi adithyanaini ,

From your description, You can create Map visual which displays hierarchical data to meet your demand following steeps below.

For example, there is a hierarchy relationship between field [AirportCountry] and [AirportCity].

Firstly, choose Map visual from visualizations pan.

Secondly, drag  field [AirportCountry] and [AirportCity] from table Top_world_airports in FIELDS pan to the Location sequentially, and drag [Altitude] to the Size.

Finally, Select the drill-down icon in top right corner to turn it on. Then, you have several options for accessing the drill-down, drill up, and expand features for visualizations that have hierarchies.

• Hover over a visualization to see and use the icons in top left corner.

• Right-click a visualization to reveal and use the menu.

• Click green bubbles visualization directly.

My pbix test file link below:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWZd-RoX6z9ApJdAKt...

You can go through these two links to learn more about the Map and drill:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

If you have any other issue, please feel free to ask.

Best Regards,

Amy

[Anonymous]

@v-xicai  Thanks

[v-xicai · Accepted solution]

Hi @Anonymous ，

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

If you have any other issue, please feel free to ask.

Best Regards,

Amy