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 difference between mine and another Tableau user's data is this:

 

Data examples: Lan 339.837,00 and Lon 1.183.279,00 / His data: Lan 34,070800, Lon 118,279800.

His data enables a color map in tableau while mine does nothing. Why does my excel format the data this way and how can i address this problem? It is very important since it is for an exam. My professor cannot locate the reason or solve this either.

Best regards! 

 

excel

3 Replies

  • 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.