search

weiweicui / PowerBI-Flowmap

MIT License
28 stars 22 forks source link

Lat and lon data incorrect #19

Open manoharraon opened 4 years ago

manoharraon commented 4 years ago

Hi,

This is an awesome visual but I'm facing issues when I put the LAT & LON for star and end city, the lat and long data is accurate I did double check at multiple websites and also on the proprietary Power BI Map visual. There are few cities where the start point would be at the top instead of the actual LAT & LON. For example I've selected Kansas US as start city and I want to see travel from Kansas US to other cities and this is how it shows. For reference the the lat and lon for Kansas in the table is 39.300643 -94.712594 respectively. Please help me fix this issue.

weiweicui commented 3 years ago

Is it possible the lat/lon fields are aggregated instead of averaged? There is a drop-down manu for every field, in which we can switch between different operations.

jucajarto commented 1 year ago

In the newest versions of PBI, this issue persists. In my case, a solution was to use the fields Origin and Destination with concatenated coordinates: Latitude, Longitude.