Forum Discussion

Danishman's avatar
Danishman
Copper Contributor
Nov 12, 2023

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...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 13, 2023
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..
  • Danishman's avatar
    Danishman
    Copper Contributor
    Nov 13, 2023
    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.
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 15, 2023
      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.