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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dunner2020
Post Prodigy
Post Prodigy

Plotting data with meter coordinates system in power BI

Hi there,

 

I have x and y coordinates (their unit is in 'meters') and sample data is as follow:

Point_x Point_y
1393427.246 4916767.201
1404938.962 4914923.079
1408257.588 4919262.785
1408578.911 4919268.221
1393367.994 4916913.063
1405745.535 4918565.383
1404544.502 4915702.339
1415210.388 4923001.518
1408309.682 4919617.785
1413830.141 4923060.024
1403506.74 4919101.903
1403898.004 4918221.265
1407236.984 4920485.674
1404360.046 4917812.396
1403262.267 4918450.047
1413788.987 4923072.168
1415105.556 4922993.073
1404331.45 4915868.449
1405317.606 4914014.232
1408775.876 4919359.098
1407116.939 4920413.94

The data type of both columns are as shown in the figure:

point_x.jpg

 

point_y.jpg

 

However, when I tired to plot the data into map, it does not show any points on the map as shown in the figure:

map.jpg

 

I am not sure why its not plotting. Not sure whether power BI supports the 'meters' as a coordinate system to plot the data. Typical demical degree used for the plotting,. Could anyone help me in rectifying the issue?

1 ACCEPTED SOLUTION
amitjzaveri
Resolver II
Resolver II

@Dunner2020  This coordinate position (in meters) seems US-based "state plane" and it is derived using 3 information Zone, X and Y. Please check this website for more information and conversion: https://www.earthpoint.us/Convert.aspx  (check for state plane in details below)

 

Once you're able to convert from the current metric to Long Lat only then your plotting will be correct.

 

Best Regards,

Amit

View solution in original post

4 REPLIES 4
amitjzaveri
Resolver II
Resolver II

@Dunner2020  This coordinate position (in meters) seems US-based "state plane" and it is derived using 3 information Zone, X and Y. Please check this website for more information and conversion: https://www.earthpoint.us/Convert.aspx  (check for state plane in details below)

 

Once you're able to convert from the current metric to Long Lat only then your plotting will be correct.

 

Best Regards,

Amit

Greg_Deckler
Super User
Super User

@Dunner2020 You are going to have to convert whatever that is into proper longitude and latitude:

https://stackoverflow.com/questions/1185408/converting-from-longitude-latitude-to-cartesian-coordina...

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler , I tried that calculation mentioned in the post. The value produced after the calculation were quite big. So I dont think its right calculation to perform. 

amitjzaveri
Resolver II
Resolver II

Please check this as I guess you will have to convert and plot.

 

Display Points within a Distance Radius on a Power BI Map

https://dataveld.com/2019/03/20/display-points-within-a-distance-radius-on-a-power-bi-map/

 

Cheers!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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