How to Map Any Background Image in Tableau

Create dataset with fields for X and Y coordinates.

The next step is to create a dataset that has at least three fields: (1) Each point you want to plot (in our case it’s player position), (2) X Position, and (3) Y Position.

For the first row, just put an arbitrary name in the cell for the point you want to plot, such as “Lookup”. The X value will be the width of the image, and the Y value will be the height of the image. At this point, my dataset looks like this (the player position coordinates still need to be looked up):

Adding a background image

Start a new workbook in Tableau and connect to the data from the previous step. Navigate to Map > Background Images, and click on the data source. This will open a new dialog box where you can choose “Add Image” in the lower-left corner. This is where you can choose which image will act as the background. If you’re following along with the baseball example, navigate to the image that you downloaded earlier.

All that is left in this step is to put the maximum value for the X and Y coordinates. If our image is 500 wide by 500 high, we would make the following entries:

X Position: 0 Left, 500 Right
Y Position: 0 Bottom, 500 Top

Also be sure to change the “Y Field” from “X” to “Y”. At this point, your screen should look like this:

Click OK to apply your changes.

Looking up X / Y coordinates to map a background image in Tableau

Start your new custom map by placing the X measure on Columns Shelf and the Y measure on the Rows Shelf. Ensure both axes are fixed at the maximum X and Y values; which are 500 for both in our case. If you need to change an axis, simply right click on the axis, choose “Edit Axis”, and fix the range at 0 to 500.

In order to look up the X and Y coordinates for each position player (or whatever you are plotting), right click on the view, hover over “Annotate”, and click “Point”. If the X and Y measures are the only fields on your view, the annotation will show you the X and Y values by default. This is what we want, but you may want to make the font larger so that it’s easier to read.

Now drag the end point of the annotation to each location you want to plot, and see how the X and Y values change. For best results, format the annotation so the line end is a circle; this way you can precisely drag the circle to the exact location you want plotted. Here is one example showing the coordinates for the Catcher:

Drag the annotation to each point you want to plot and record the coordinates in your dataset. Note that you don’t need to record the decimals. Here is a look at my data with the X and Y coordinates for each player position:

Refresh your map

After all coordinates have been recorded in your dataset, save your data and refresh the data source in Tableau.

Drag the field you are plotting, such as position in the baseball example, to the Detail Marks Card. You should now see a circle at each position, like this:

Finalizing the custom view

There are a few items you can do to finalize your custom Tableau map:

– Remove the annotation by right-clicking on it and selecting “Remove”.

– Hide the axes by right-clicking on each one and deselecting “Show Header”.

– Format your marks; my favorite is a filled circle with a custom color and white border.

– Filter out the “Lookup” X and Y coordinates. You will notice a mark in the upper-right corner of your new custom map. You can filter this out by either right-clicking on it and choosing “Exclude”, or for better long-term results, remove this row from your underlying data and refresh your view.

– Optional: You can now add measures to your underlying data for each position to visualize different metrics on your customized view (i.e., size the circles by fielding %).

The final custom Tableau map will look like this:

Thanks for reading,
– Ryan

This content is excerpted from my book Practical Tableau: 100 Tips, Tutorials, and Strategies from a Tableau Zen Master published by O’Reilly Media Inc., 2018, ISBN: 978-1491977316. Get the book at Amazon.