Forum Discussion
Danishman
Nov 12, 2023Copper Contributor
Problems with lat and lon formatting matter in my excel due to OS.
Hi, I live in Denmark and i occur some lan and lon problems when i separate the columns in this dataset https://data.lacity.org/Public-Safety/Crime-Data-from-2020-to-Present/2nrs-mtv8 The dif...
Danishman
Nov 13, 2023Copper Contributor
Hi Jan,
Thank you for the response! this solved the problem with my formatting, but now when i try to use the lon and lat all values turn to null inside Tableau when i assign them as their respective geo.
Thank you for the response! this solved the problem with my formatting, but now when i try to use the lon and lat all values turn to null inside Tableau when i assign them as their respective geo.
JKPieterse
Nov 15, 2023Silver Contributor
Have you set the correct data type for the Lat and Lon columns in PowerQuery? I don't know which data type tableau expects them to be.