Forum Discussion
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...
Before importing the data, set the locale to e.g. US English here: Data, Get Data, Query Options, Regional settings tab, set tu US English. After that, set up that query again..
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.
- 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.