cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elliotdixon Member
Member

Globe Map - increase resolution

I have given the Globe Map a go and got it working however my datapoints are very close together. Not really global.

 

End up with a picture like this (thats all of New Zealand under there)

Globemap blur.jpg

I realise it's called "Globe Map" but am wondering if anyone knows a way to zoom in to more localised data? Also if its possible to remove the bars - I am really just after the heat map. This is the current workaround until there is a real heatmap in Power BI.

Cheers

 

1 ACCEPTED SOLUTION

Accepted Solutions
elliotdixon Member
Member

Re: 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.
2016-02-23 12_01_18-Mix - Power BI Desktop.png
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 Smiley Very Happy

ED

13 REPLIES 13
Super User
Super User

Re: Globe Map - increase resolution

Very difficult to recreate this without some sample data and information on how you configured your map, any chance you can post?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
elliotdixon Member
Member

Re: Globe Map - increase resolution

HI @Greg_Deckler  Data is pretty basic.

 

LatLong is used for the location data - it is correct as I can see it coming through and it does actually look right on the Globe Map.

Events are overspeeds for our trucks.

Excel sheet of some randomized data like what I am using HeatMapData
I use code

Events1 = CALCULATE(SUM(Events[TotalOccurs])

Code wise nothing seems to be incorrect - its just that the map must have some sort of zoom level set as the default. I need to change the resolution so that the detail is shown.
Cheers

 

Super User
Super User

Re: Globe Map - increase resolution

Well, using your sample data, what I get looks pretty good. I had to split the StartLongLat field into two fields using "," separator then recombine in reverse order:

 

Custom = Text.From([StartLongLat2]) & "," & Text.From(StartLongLat1)

 

Then I created a custom measure per your formula:

 

Events1 = CALCULATE(SUM(Events[TotalOccurs])

 

Then I created a Globe Map and put "Custom" into the Location area and Events1 into the Values area. This is what I got back:

 

 events.png

 

Edit: Oh wait, you are using a custom visual, I am using the default "Map" visual from Power BI. Do you need to use the "Globe Map" visual?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Globe Map - increase resolution

Since there are no filters/conditions in the Events1 Measure - why use CALCULATE?

greggyb New Contributor
New Contributor

Re: Globe Map - increase resolution

There is a native heat map in Power BI, it's the filled map visualization. This visual will only work with geographic boundaries that Bing understands: Postal Code, City, State / Province, Country, Continent in increasing order of magnitude.

Super User
Super User

Re: Globe Map - increase resolution

@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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


greggyb New Contributor
New Contributor

Re: Globe Map - increase resolution

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.

 

Capture.JPG

Super User
Super User

Re: Globe Map - increase resolution

@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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


greggyb New Contributor
New Contributor

Re: Globe Map - increase resolution

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.