Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Could anyone suggest solution. Currently I got GEO code information as below that include both Lattitude and Longitude in same column. And I would like to seperate column for Lattitude and Longtitude to plot in map. How to separate column based
GEO Code |
6.803xxxx, 101.140xxxx |
14.62xxxx,103.27xxxx |
18.12xxxx,100.14xxxx |
17.15xxxx, 99.13xxxx |
Solved! Go to Solution.
Hi @Anonymous
You can do this by using Split Column by Delimiter option in the Power Query Editor.
_______________
If I helped, please accept the solution and give kudos! 😀
@Anonymous , best is that you split that in power query/ data transformation mode
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi @Anonymous
You can do this by using Split Column by Delimiter option in the Power Query Editor.
_______________
If I helped, please accept the solution and give kudos! 😀