Drill down from States to district in Power BI

[jithinjoseph]

Hi, I was mapping Sales Amount details for States in India. I wanted to drill down from State to district level. Is it possible to drill down from State to district in Power BI maps?

[v-haibl-msft · Accepted solution]

@jithinjoseph

It should be possible to do it. Assuming we have a table which contains India State, District and Sales as below.

You can drag columns into Map visual, then click the drill down button as below.

Best Regards,

Herbert

[jithinjoseph]

Hi Herbert,

Thanks for the reply.

I followed your steps for a sample population data and came up with the following:

But drill down using bubble maps was a cluster mess of bubbles:

So I tried filled maps which looks much better. It looks much readable

Thank you very much.

[gkarakoti]

Hi

R u getting the right geographical boundries of Indian Districts in drill down at district level. 

I seems to getting it wrong in many cases. I think powerbi doesnt have inbuilt geoboundary for district. 

For state this data seems ok but not at district. 

Any insights will help.