Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to 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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
79 | |
63 | |
52 | |
46 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |