Forum Discussion
Post ProdigyChanging x and Y coodinates datatype
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.
Hi Dunner2020 ,
I notice that you have posted the simliar issue to convert meters to corresponding Latitudes and Longitudes:
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- amitchandak
Super User
Dunner2020 , I think the only option in the Data category, Right to format box. But I doubt it has what you need.
Dunner2020amitchandak , 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.
- 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
v-yingjlCommunity Support
Hi Dunner2020 ,
I notice that you have posted the simliar issue to convert meters to corresponding Latitudes and Longitudes:
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
