topic Re: Drill-Down for Maps? in Developer

Drill-Down for Maps?

residentx — Thu, 28 Jan 2016 13:27:17 GMT

I talked to the Bing Maps about PowerBI and they referred me back to this group.

Is there a way to do drill-downs for maps?

Is there a way for me to do click/zoom through on maps in this order: Country, State, County, City, Zipcode(s), Location/address?

Re: Drill-Down for Maps?

Greg_Deckler — Thu, 28 Jan 2016 13:39:41 GMT

Yes, use a filled map and then turn on drill down, it is the little down arrow in the upper right of the visualization.

You want to make sure all of your columns have the right Data Categorization, they should all show up with little globes next to them, then place them, in order into the Location field of the filled map visualization.

Re: Drill-Down for Maps?

residentx — Thu, 28 Jan 2016 14:06:42 GMT

Thanks Smoupre, I'll build the spreadsheet later this morning. I'll post my results later today.

Re: Drill-Down for Maps?

greggyb — Thu, 28 Jan 2016 15:56:13 GMT

Just a note. The filled map will not support an address / specific location. These data types represent a point on a map. You cannot fill a point. The drill down hierarchy for a filled map ends at Postal Code data category.

A regular map (plots pies in the center of the location identified, not a filled region) can go down to point locations.

Re: Drill-Down for Maps?

residentx — Thu, 28 Jan 2016 17:10:12 GMT

Greggb, thanks for the comment. I'll sort it out later today. I've been on calls all day. I won't work on this till later today.