Filled maps (choropleth) in Tableau - Dashboard Guide

Dashboard Mode - Filled maps (choropleth)

Business Question

Which US states have the highest total sales, and how do sales compare across states?

Sample Data

State	Sales
California	300000
Texas	250000
New York	200000
Florida	150000
Illinois	100000
Ohio	90000
Georgia	85000
Washington	80000

Dashboard Components

• KPI Card:
  Shows Total Sales across all states.
  Formula: SUM([Sales])
  Result: 1,255,000
• Filled Map (Choropleth):
  US map colored by sales per state.
  Color intensity increases with sales.
  Data: State and Sales columns.
  Tooltip shows state name and sales amount.
• Sales Table:
  Tabular view of states and sales sorted descending.
  Helps compare exact sales numbers.

Dashboard Layout

+----------------------+-----------------------+
|      KPI Card        |    Filled Map (US)     |
|  Total Sales: 1.255M |  (States colored by   |
|                      |   sales intensity)    |
+----------------------+-----------------------+
|                   Sales Table                    |
|      (States and sales sorted descending)      |
+------------------------------------------------+
  

Interactivity

Filter by Region: Users can select regions (e.g., West, South) to update the filled map, KPI card, and sales table simultaneously.
Hover on Map: Hovering over a state highlights it and shows a tooltip with sales details.
Sort Table: Users can sort the sales table ascending or descending to explore data.

Self Check

If you add a filter to show only the "West" region, which components update and what changes occur?

• The KPI Card updates to show total sales only for West region states.
• The Filled Map colors only West region states with sales data; other states appear greyed out.
• The Sales Table filters to show only West region states sorted by sales.

Key Result

A dashboard showing total sales by US state using a filled map, a total sales KPI, and a detailed sales table.