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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Dunner2020
Post Prodigy
Post Prodigy

Splitting 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? 

1 ACCEPTED SOLUTION
amitchandak
Super User
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/

 

View solution in original post

1 REPLY 1
amitchandak
Super User
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/

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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