Forum Discussion
Globe Map - increase resolution
Cheers to all who helped with this one. I ended up going with just the basic map as it showed the details I need for now. Hopefully an update soon will allow further manipulation of the way it is presented in PowerBI.
One remaining issue (which I would have thought impossible) is that I have events occuring in exactly the same point even with GPS coordinates down to the second! PowerBI then joins the two events and increases the dot size (and adds the value) annoying but something I guess I can live with for now.
Great help and advise on the forums again though :smileyvery-happy:
EDBit late to the party I guess, but NZ is not a region of the world understoof by Bing. I have had lots of success heatmapping down to property size for NZ, but this has all been based on specialist polygons in other tools. I have had some luck bringing in shapes in my queries but it seems to slow down performance more than it should. Your last attempt is the best you will get out of the current powerbi suite. Bring in post code and you get mapping points all over the world, your lat/lng is the best you will get at the mo.
greggyb - I tried the filled map as well when I was testing this, the results were unsatisfactory. I really could get it to do much of anything other than turn New Zealand blueish-green.
Sean - Good point, but I don't thinkt that is the source of elliotdixon's woes.
I don't have any data set with NZ addresses handy, but here's how the heat map looks for me with real data from a demo I'm putting together presently. I've got zip codes that have the data category set as 'Postal Code', and each code gets its own delineated block.
It's important to make sure that all of the geo-data is categorized properly in the modelling ribbon menu.
greggyb - elliotdixon posted a link to her data in a post above, HeatMapData. Unfortunately it only has Long/Lat data which doesn't play nice with Filled Maps. Looks like telemetry data to me.
Ah, sorry I missed that link. Yeah, a heat map can only work with a region. There's no way to create a heat map with lat/lon points - it just doesn't make sense. How can you shade a region, when the data you've got only represents a single point on the earth's surface? The only way to shade a region is to have an outline defined. Using the native maps, only standard geo-political borders are included.
I'd probably pursue the Synoptic Panel visualization and define regions that each lat/lon pair should fall into, persisting that region name as an attribute in the geography dimension. Any SVG image can be used, and you can get very fine grained control over where your borders lie. It's either that or mapping lat/lon to postal codes, which is the finest granularity supported by the Bing maps API that makes sense in a heatmap type chart.