How to visualize Origin Latitud/Longitud and Destination Latitud/Longitud using flow maps

[o59393]

Hi all

I have mapped the Origin Latitud/Longitud and Destination Latitud/Longitud, with its respective country of origin and destination as seen below:

When I use the flow map with the coordinates nothing shows in the map:

However If I use the country/destination name it works (but it uses the center of gravity of each country):

Also it shows only one origin point in Brazil, when there are actually 2 origin points in that country (see first image of coordinates)

How can I get to work the map with latitudes and logitudes?

Pbix attached:

https://1drv.ms/u/s!ApgeWwGTKtFdh0HYtKf6RfN0rTZM?e=fEKIZh

Thanks !!

[sanjibtiwari123]

Create two columns:

Origin = CONCATENATE(origin_latitude, CONCATENATE(", ", origin_longitude))

Destination = CONCATENATE(dest_latitude, CONCATENATE(", ", dest_longitude))

Use the origin column in origin and destination column in destination in the flow map attributes

The map uses bing search to locate the exact point so this works.

[themistoklis]

@o59393 

Apart from the origin and destination coordinates (lats and longs) you should also add the Origin and Destination country fields.

Then data will be displayed on the map

[o59393]

Hi @themistoklis 

It's showing me this:

It's not locating correclty the origin/destinations in LATAM 😕

Any idea?

Thanks.

[themistoklis]

Hello @o59393 

It seems that the coordinates are not correct.

I checked couple in googlemaps and they are located in the sea.

e.g.

22.9682

-43.1729

[o59393]

Hi @themistoklis 

90% ready, the only problem I see is with Brazil,

The coordinates are correct (see the first 2 maps locations), howevever the 3rd map is not locating Brazil corectly:

Seems like it had moved all to the left:

If you use the slicer on Brazil see what happens:

Any idea how to fix it?

I attach pbix

https://1drv.ms/u/s!ApgeWwGTKtFdh0LjvvMviPmNd3dt?e=Wv7dX0

Thanks!

[themistoklis]

@o59393 

I checked your dataset and and it seems that for Brazil you have dupicated rows

you need to remove these duplicated rows and keep the correct set of coordinates for Brazil.

Currently there are the following coordinates:

-22.936389

-43.376944

-12.835278

-38.404444

[o59393]

Hi @themistoklis 

That is correct it should be 2 origin points on Brazil (2 manufacturing sites instead of one).

Do you need the csv file?

Thanks!

[themistoklis]

@o59393 

If you could share it with me that would be great. Thank you

[themistoklis]

@o59393 

I checked again and the issue is the visual itself.

When you have the same origin with 2 different coordinates then it automatically sums the values.

When I filtered the data and I selected only one set of coordinates for Brazil then the data were displayed correctly. See image below.

Unfortunately you need to use one set of coordinates per origin.

[plaralema]

I have the exact same problem with FlowMap.

When you have two origin points, with correct lat/lon, visual shows -in my case- the average of the two origin points coordiantes (or sum) and that means one can see only one origin point...  but if I use a slicer for origin names, and select each one separately, it shows the correct map.

i can't find a proper solution (no calculation for coordinate fields doesn't work) 

....and another thing with flowmap is that takes forever to make any change and even it freezes, making powerbi desktop to crush. I don't have a lot of data (6000 rows ) so i'll try with ICON MAP to my dashboard. 

[o59393]

And it possible to have some sort of slicer to filter by Brazil North and Brazil South?

So that it doenst sum the coordinates?

Thanks for the help!

[themistoklis · Accepted solution]

@o59393 

Yes you can add Brazil North and Brazil South.

I have just added a new column next to origin column (in th excel file) where the first set of coordinates are named as Brazil North and the other Brazil South.

On slicer on top i have added the new column BUT on the visual i have kept the old origin column (the filtering is done by the slicer on top)

See image and csv dataset attached

[bxgalleg]

Is there a way to do it just with latitude and longitude? In my particular problem, I have more than 300 origins and destinations coordinates; is there a way to do a flow map just using coordinates of origin and destination?

[o59393]

Awesome!

Can you please share Pbix too?

Thanks

[o59393]

Here you go

https://1drv.ms/u/s!ApgeWwGTKtFdh0MAvfjAGn8Fsr9P?e=TO4m7p

Please feel free to make the changes on the excel file. It´s basically to have visible 2 origin points in Brazil (one north and one south)

Thanks!

[themistoklis]

@o59393 

Please see my comments on previous post

[o59393]

Sure, please check the last Pbix and excel shared since I added the north and south for Brazil

Thanks!