Show City & State Data on One Tableau Map

Step 1:

Double Click [State] to create a map. Double click [City]

Step 2:

Right click [Sales] and create a calculated field. You will need a duplicate of your measure in order to show both types of map.

Step 3:

Drag the new calculated field to color, and size.

Step 4:

Hold the control button down to copy the latitude pill. This will give you a dual axis map.

Step 5:

On one of your axis, remove [city], and change the mark type to filled map.

Step 6:

Replace the new calculated field with sum of sales on size and color.

Step 7:

Click the dropdown on the second latitude pill and select “Dual Axis”