Some locations of Departments are so far from real location (mapping visualization)

[Anonymous]

peace everyone 🙂

When I import Excel file to Power BI Desktop(or Service online) , some locations of Deptments appears (in mapping visualization)so far from real location in mapping(thousands of Kilometers!).

all locations are in Riyadh,Saudi Arabia,but in dashboard they appears in Europ,Turkey and more.

How can I reolve this problim?

the data in excel looks like this( 4 Columns/fields):

Management      HQ Management

locations name :  ادارة التغيير في حي العليا

                X Y :  24.6756436.46.7229218  (this X Y appears location in Turkey!)

HEADCOUNT : 100

-------------------------------------------

HEADCOUNT : (number of employees)

locations name: (name of Section + district name)

X Y : Coordinates

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to split the latitude and longitude into tow different columns and then use them on your maps.

Add the following two columns on the query editor:

//Latitude 
Text.BeforeDelimiter ([XY] , ".", 1)


//Longitude
Text.AfterDelimiter ([XY] , ".", 1)

Be sure to categorize each one as latitude and longitude:

Now use this in your maps: