Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello All -
Using the MAP visualization, I've plotted number of orders placed around the world from our different online stores. I'd like the map to represent the totals depending on the zoomed in level you are at. So, world view shows numbers by country; zoom in to show by Region (State or Province), and then finally right into City. I've tried putting each of these three fields into the Location criteria of the map, and played with the order, but it doesn't seem to be doing what I wish.
I have made sure to categorize my fields accordingly also (so City = City, Region = State or Province, Country = Country)
Thanks!
Travis
Solved! Go to Solution.
OK, so I guess I should have explored those drill down buttons a bit more. I have managed to figure this out now. For anyone else wondering how this all works...
- Drill Up (using arrow in top left corner) on your map to your highest level
- click "turn on Drill Down" arrow in top right corner
- click on data point you wish to center on (ie. Country)
- this should automatically drill down to the next level (ie. States)
- click on a new data point you wish to center on
- this will now take you to new level of detail (ie. Cities)
Hope this helps someone else out!
Travis
So I have now noticed the Drill Down buttons on the corners of the map. I guess these are supposed to do exactly what I'm asking, but I believe I have bigger issues. The data being plotted isn't correct, nor does it stay consistent. For instance I know that I have over 6000 orders that should show up in Ontario, and the map is not showing any. I should have orders showing in most if not all States, and the map only plots a handful of them. Let's say one of those States has 1000+ orders, and then I drill down to next level, I don't get those 1000 orders plotted out across the different cities.
I can take all of this same data and view just in a table, and correct numbers and places are represented. Any ideas why this isn't being translated onto the map.
Thanks.
Travis
OK, so I guess I should have explored those drill down buttons a bit more. I have managed to figure this out now. For anyone else wondering how this all works...
- Drill Up (using arrow in top left corner) on your map to your highest level
- click "turn on Drill Down" arrow in top right corner
- click on data point you wish to center on (ie. Country)
- this should automatically drill down to the next level (ie. States)
- click on a new data point you wish to center on
- this will now take you to new level of detail (ie. Cities)
Hope this helps someone else out!
Travis
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 45 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 108 | |
| 108 | |
| 39 | |
| 33 | |
| 25 |