Sometimes Tableau will not recognize one or more of the location names in your data. When this happens those values are marked as unknown in the lower right corner of the view. This often happens because your data values may be spelled incorrectly or use an abbreviation that Tableau does not recognize. When this happens, you can edit the unknown location names to map to known locations.
To edit unknown location names
- In the bottom right corner of the view, click the special values indicator. This opens the Special Values dialog box.
- In the Special Values dialog box, select Edit Locations.
Note: If the special values indicator is not visible, you can also select Map > Edit Locations.
In the Edit Locations dialog box, click on one of the Unrecognized cells to match a known location to your unknown data. When you click on an unrecognized cell, a search box appears. As you begin typing in the search box, Tableau generates a list of possible locations. Select a location from the list.
Alternatively, you can select Enter Latitude and Longitude from the drop-down menu to manually map the value to a location on the map.
Note: When you type a latitude and longitude, enter the values in decimal format.
Both unrecognized and ambiguous locations can be listed in the Edit Locations dialog box. You can usually fix ambiguous locations by specifying the Country/Region and/or State/Province options in the Geographic Roles section of the Edit Locations dialog box. For example, if you have several cities that are ambiguous, you can specify a State/Province to fix them.
Restrict Locations in the List
By default, all possible locations are listed in the drop-down menu. To restrict the list to locations that have not yet been matched to your data, select the Show only unmatched locations in drop-down list option in the bottom left corner of the Edit Locations dialog box.