Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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
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
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.
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.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |