Show City & State Data on One Tableau Map
Updated: May 14
Double Click [State] to create a map. Double click [City]
Right click [Sales] and create a calculated field. You will need a duplicate of your measure in order to show both types of map.
Drag the new calculated field to color, and size.
Hold the control button down to copy the latitude pill. This will give you a dual axis map.
On one of your axis, remove [city], and change the mark type to filled map.
Replace the new calculated field with sum of sales on size and color.
Click the dropdown on the second latitude pill and select “Dual Axis”