That's because your excel file has those values formatted as text and tableau honors excel's data type - which is very good.
You can convert them to decimal numbers in data source editing screen:
and then tableau lets you use them as geo lat/lon:
and you get your map
geocode.twbx 59.9 KB
Please verify geographic roles - looks like you set Lat or Lon twice or the other way around.
latitude and longitude are setted well.
I think that the problem could be the format of the variable. When i set Number(decimal) my coordinate changes if compared with yours. I mean, you have 45.40125 (below in the right)
and i have 4540125,00.
Could it be the difference that makes the map not working??
Thanks a lot again!!
1 of 1 people found this helpful
In this case I think you have to adjust your locale/regional settings in excel, tableau or OS so that it recognizes dot '.' as decimal separator. You probably have it set to comma now.
You may also replace dots with commas as last resort
Hi Lukasz, sorry for my late answer.
Finally, substituting dots and commas the dataset worked, so thank you a lot for your usefull help!
Have a nice day