Plotting data with meter coordinates system in power BI

[Dunner2020]

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:

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

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?

[amitjzaveri · Accepted solution]

@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]

@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...

[Dunner2020]

@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]

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!