Forum Discussion
Power BI Desktop Map and excel 2013
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.
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!