Forum Discussion

elliotdixon's avatar
elliotdixon
Responsive Resident
10 years ago
Solved

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) ...
Need Help
  • elliotdixon's avatar
    elliotdixon
    10 years ago

    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:

    ED

  • samdthompson's avatar
    samdthompson
    10 years ago

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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

  • elliotdixon's avatar
    elliotdixon
    Responsive Resident
    10 years ago

    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

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      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:

       

       

       

      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?

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

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