Combining Generated and Datasource-Based Latitude and Longitude on Dual-Axis Map

Issue

How to combine data source-based latitude and longitude with generated latitude and longitude on a dual axis map.

Environment

Tableau Desktop

Resolution

Option 1: Upgrade to Tableau Desktop 2018.1 or later

Starting in Tableau Desktop 2018.1 it is possible to create a dual axis map with custom and generated Latitude and Longitude values. For full directions, see Create a dual-axis map from a combination of generated and custom latitude and longitude fields

Option 2: Use Custom Geocoding

Create a custom geocoding .CSV file that correlates all of the latitude/longitude coordinates with the required nomenclature. For more information, see Creating an Import File.
Import the custom geocoding into Tableau Desktop. For more information, see Importing Custom Geocoding.
Use the name-based recognition to set up a dual axis view exclusively based on generated latitude and longitude values.

Option 3: Replace one axis of the map with a background image

Background images will not have the same functionality as a map axis. For example, it is not possible to select marks on a background image or see tooltips. For full directions, see Use Background Images in Your Views

Cause

Early versions of Tableau Desktop did not recognize that the latitude/longitude of one dimension are related to the lat/long of another dimension (such as the custom lat/long compared to generated lat/long). Therefore, when the second set of lat/long are placed on the row/column shelves, they restrict the potential points of the dual axis. In effect, any dual map information can only be plotted on the secondary map if the lat/long coordinates match the lat/long already on the view.