Forum Discussion

AdrianOConnor's avatar
AdrianOConnor
New Member
11 years ago

Power BI Desktop Map and excel 2013

Questions on Power BI Desktop.   New Dashboard\Report and I get data from an excel file (Name, Latitude, Longitude, Type and Value).   When I click on the world map, it asks me for Location, Lege...
WillT's avatar
WillT
Icon for Community Admin rankCommunity Admin
11 years ago
Hi Adrian. We use Bing to determine where to plot points, so we send them the values in the Location field to geocode. That gives us a lat/lon, but it's not always right (if you just send 'Paris', they return Paris, France rather than Paris, Texas for example). You can use lat/lon from your own data to correct this. We do know about the issue where it's only corrected once you've put something in Values - you shouldn't need to specify that - and we're working on a fix. You can try creating a measure with a fixed value and put that into Values, then they should all appear the same size. Thanks!
fitnesspowerbi's avatar
fitnesspowerbi
Icon for Advocate II rankAdvocate II
11 years ago

I have tried using the lat/lon to plot the location of specific points of interest in my data, as you suggested. The lat/lon are set as the data type and category however when I attempt to plot it, the lat/lon is summed and the correct points are not plotted. How do I get around this? I have specific points that should be plotted with the name of the location appearing on the map.

  • sjkp's avatar
    sjkp
    Icon for Advocate II rankAdvocate II
    11 years ago

    I have the same issue, and to me it seems like lat-long currently cannot be used reliably, which is a shame I can think of lot of scenarios where you would want to map a location that is not an address. 

     

    • WillT's avatar
      WillT
      Icon for Community Admin rankCommunity Admin
      10 years ago

      Hi folks - sorry for the silence and not responding to the thread. One thing that is worth noting is that you do need a field in the Location area in the Field Well, even when you're using the lat/long values. That's so we know which field to split the data up over. For example, if you have this data:

       

      Office  Lat    Long   Amount

      Paris   48.8   2.34   542

      Paris   48.8   2.34   241

      London  51.5  -0.05   155

       

      Then putting 'Office' into the Location field shows that you want to aggregate the values for each Office. Again, that needs to be unique so make sure to created a calculated column to distinguish between Paris, France and Paris, Texas.

       

      We're working on improvements in this area to make it easier to work with maps, please stay tuned!