Changing x and Y coodinates datatype

[Dunner2020]

Hi there,

I have two columns that represent the x and y coordinates in meters unit as shown in the picture:

However, the data type of both columns are decimal number. When I tried to change their datatype, I could not find any option to change it into demographic information:

I am not sure, how could I change its data type: Any help would be really appreciated.

[v-yingjl · Accepted solution]

Hi @Dunner2020 ,

I notice that you have posted the simliar issue to convert meters to corresponding Latitudes and Longitudes:

https://community.powerbi.com/t5/Desktop/Plotting-data-with-meter-coordinates-system-in-power-BI/td-...

I think the convert regulattion provided by https://www.earthpoint.us/Convert.aspx  (check for state plane in details below which is mentioned by @ amitjzaveri could help you to solve this issue.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Dunner2020 , I think the only option in the Data category, Right to format box. But I doubt it has what you need.

[Dunner2020]

@amitchandak , I am getting data from ArcGIS. The x and y coordinates are in meter system. They are not in decimal degrees system. Does Power BI recognise x and y coordinates in meter system. I am trying to plot on the map but it does not show any thing on the map.

[Greg_Deckler]

@Dunner2020 Can you explain meter system? Like a system of water meters or something and these are the coordinates. If so, what is the reference point for the coordinate system being used by the meters?

[Dunner2020]

@Greg_Deckler , I am getting data from ArcGis. In ArcGIS  the display unit of coordinates is setup to meters. I tried to set to decimal degrees but when data comes out from ArcGIS, its always in the meters. 

[amitchandak]

@Dunner2020 , I doubt you have something like that.

Can you check you can convert them on long lat with help from this -https://sciencing.com/calculate-antipode-6170267.html