Forum Discussion
Post ProdigySplitting column in X & Y coordinates
Hi there,
One of my tables in power BI is connected with a ArcGIS. That table has column which looks like following:
| SHAPE |
| POINT (1407236.9840000002 4920485.674) |
| POINT (1407116.9390000002 4920413.94) |
| POINT (1407065.721 4920193.42) |
| POINT (1407093.5889999997 4920381.022) |
| POINT (1407178.352 4920147.297) |
| POINT (1407122.5259999996 4920155.973) |
| POINT (1407132.7300000004 4920242.326) |
| POINT (1407182.3339999998 4920423.836) |
| POINT (1407113.8310000002 4920109.255) |
| POINT (1407200.517 4920453.004) |
| POINT (1407075.244 4920080.767) |
| POINT (1407149.011 4920394.246) |
| POINT (1406982.9960000003 4920018.768) |
| POINT (1407085.4000000004 4920221.804) |
| POINT (1407141.0089999996 4920324.408) |
| POINT (1407199.9000000004 4920523.919) |
As you can see that column contains the x and y coodinates. I want to plot these coordinates on 'ArcGis Map for power BI' visualization. Is there any way in Dax to split the column in x and Y coordinates?
Dunner2020 , I think first you should replace
"POINT (" with ""
and ")" and ""
and then split the this by " " (Space) in two columns.
You have option for both in power query/edit query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
https://www.howtoexcel.org/power-query/bulk-replace-values/
1 Reply
- amitchandak
Super User
Dunner2020 , I think first you should replace
"POINT (" with ""
and ")" and ""
and then split the this by " " (Space) in two columns.
You have option for both in power query/edit query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
https://www.howtoexcel.org/power-query/bulk-replace-values/