Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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

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

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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:

MFelix_0-1604665294359.png

 

Now use this in your maps:

MFelix_1-1604665373244.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

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:

MFelix_0-1604665294359.png

 

Now use this in your maps:

MFelix_1-1604665373244.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.