Creating Filled Maps in Tableau
1. Introduction to Filled Maps
A Filled Map in Tableau is a geographical visualization that displays data by filling geographic areas with different colors. These areas can represent countries, states, provinces, counties, or other supported geographic regions. Filled maps are also known as choropleth maps.
Filled maps help users identify geographical patterns, compare regional performance, and understand how business metrics vary from one area to another. For example, a company can create a filled map of India to compare sales across states. States with higher sales can appear in one color range, while states with lower sales appear in another.
Unlike symbol maps, which display symbols at geographic locations, filled maps color the geographic boundaries of regions. They are particularly useful for comparing regional totals, percentages, rates, and other aggregated measures.
Learning Objectives
- Understand the concept and purpose of filled maps.
- Learn the difference between filled maps and symbol maps.
- Identify the geographic fields required for filled maps.
- Create filled maps using Tableau Desktop.
- Apply colors to geographic areas using dimensions and measures.
- Customize colors, labels, tooltips, and map borders.
- Use filters and hierarchies for geographical analysis.
- Identify and solve common filled map problems.
2. What Is a Filled Map?
A filled map is a visualization in which each supported geographic region is represented by a polygon whose interior is filled with a color. The color usually represents a measure or category associated with that region.
For example, if a dataset contains State and Sales fields, Tableau can display the states as filled geographic areas and color each state according to its sales value.
Example Dataset
| State |
Sales |
Profit |
| Maharashtra |
500000 |
100000 |
| Gujarat |
350000 |
70000 |
| Karnataka |
420000 |
85000 |
| Rajasthan |
250000 |
40000 |
| Tamil Nadu |
390000 |
75000 |
When State is used as the geographic dimension and Sales is placed on Color, Tableau can color the recognized state polygons according to the sales values. The resulting map helps users compare regional sales performance visually.
Key Characteristics
- Displays geographic areas as filled polygons.
- Uses color to represent measures or categories.
- Supports geographic comparisons and regional pattern analysis.
- Can display labels and tooltips for additional information.
- Works best when the geographic boundaries match the level of the data.
3. Why Are Filled Maps Used?
Filled maps are useful when the business question concerns how a value varies across geographic regions.
- Regional sales analysis: Compare sales across states, provinces, or countries.
- Profitability analysis: Identify regions with higher or lower profit.
- Population analysis: Compare population-related measures across geographic areas.
- Market analysis: Identify regions with stronger market performance.
- Customer analysis: Compare customer counts or customer rates across regions.
- Healthcare analysis: Display disease rates or healthcare access measures by region.
- Operations analysis: Compare service coverage, regional demand, or performance by territory.
Example Business Scenario
A retail organization wants to understand which states generate the highest sales. A filled map colors each state based on total sales. Management can use the visualization to identify strong and weak regions and investigate the factors behind regional differences.
4. Filled Maps vs. Symbol Maps
Filled maps and symbol maps are both geographical visualizations, but they represent locations differently.
| Feature |
Filled Map |
Symbol Map |
| Visual representation |
Colors geographic areas. |
Displays symbols at geographic points. |
| Geographic unit |
Countries, states, provinces, counties, and supported areas. |
Cities, stores, customers, facilities, or coordinates. |
| Primary visual encoding |
Area color. |
Symbol size, color, or shape. |
| Typical use |
Comparing regional totals, rates, or categories. |
Comparing individual locations or showing point distributions. |
| Example |
Sales by state. |
Sales by individual store. |
| Main limitation |
Large regions can visually dominate smaller regions. |
Symbols can overlap in densely populated locations. |
Important: Choose a filled map when the geographic area itself is important to the comparison. Choose a symbol map when the analysis focuses on individual points or locations.
5. Requirements for Creating Filled Maps
Before creating a filled map, prepare your dataset and confirm that Tableau can recognize the geographic fields.
Required or Useful Fields
| Field Type |
Examples |
Purpose |
| Geographic dimension |
Country, State, Province |
Identifies the areas to display. |
| Measure |
Sales, Profit, Revenue |
Controls the fill color according to quantitative values. |
| Category dimension |
Region, Segment, Status |
Colors areas according to categories. |
| Additional location context |
Country, State |
Helps resolve ambiguous geographic names. |
| Time field |
Order Date, Year |
Supports comparisons across periods. |
Tableau supports built-in geographic boundaries for many recognized locations. If a location is unsupported or the required geographic boundary is unavailable, you may need spatial data or another mapping approach.
6. Understanding Geographic Roles
A geographic role tells Tableau how to interpret a field as geographical information. Tableau can use recognized geographic roles to match location names with geographic coordinates and supported map boundaries.
Common Geographic Roles
- Country/Region
- State/Province
- County, where supported
- City
- ZIP Code/Postcode, where supported
- Latitude and Longitude
How to Check Geographic Roles
- Locate the geographic field in the Data pane.
- Right-click the field or open its field menu.
- Select Geographic Role.
- Choose the role that matches the field's values.
- Verify that Tableau recognizes the locations correctly.
For example, a State field should have the State/Province geographic role. If a field contains state names but has an incorrect role, Tableau may fail to create the intended map or may interpret its values incorrectly.
7. Step-by-Step: Creating a Basic Filled Map
Follow these steps to create a filled map in Tableau Desktop.
- Open Tableau Desktop.
- Connect to a dataset containing geographic fields such as State or Country.
- Open a new worksheet.
- Locate the required geographic field in the Data pane.
- Verify that the field has the correct geographic role.
- Double-click the geographic field, such as State, to generate a map.
- On the Marks card, open the mark type drop-down menu.
- Select Map to create a filled polygon map.
- Drag a measure such as Sales to Color.
- Review the color legend and confirm that the geographic areas represent the intended values.
Process Flow
Connect to Data
↓
Open a Worksheet
↓
Add a Geographic Field
↓
Generate a Map
↓
Select Map on the Marks Card
↓
Drag a Measure to Color
↓
Customize and Analyze the Filled Map
Another option is to use Tableau's Show Me panel and select a filled map when the selected fields are suitable. The exact options available depend on the data and Tableau version.
8. Creating a Filled Map Using Sales Data
In this example, you will create a filled map to compare sales across Indian states.
Sample Dataset
Country,State,Sales,Profit
India,Maharashtra,500000,100000
India,Gujarat,350000,70000
India,Karnataka,420000,85000
India,Rajasthan,250000,40000
India,Tamil Nadu,390000,75000
Procedure
- Import the dataset into Tableau.
- Confirm the data types of Country, State, Sales, and Profit.
- Assign the appropriate geographic roles to Country and State if necessary.
- Open a worksheet and double-click State.
- Confirm that Tableau recognizes the locations correctly.
- On the Marks card, select Map.
- Drag Sales to Color.
- Open the Color menu and choose a suitable sequential palette.
- Drag Profit to Tooltip.
- Optionally add State to Label if the labels are readable.
- Check for unknown locations and missing state boundaries.
- Rename the worksheet to Sales by State.
Expected Result
Each recognized state is displayed as a filled geographic area. The fill color represents sales, allowing users to compare the recorded sales values across states. Tooltips can provide additional profit information when users hover over a state.
Data note: The values in this exercise are illustrative. A production analysis should use verified data and appropriate geographic identifiers.
9. Understanding the Marks Card
The Marks card controls how data is displayed in a Tableau visualization. For filled maps, the Map mark type creates filled geographic areas, while other Marks card options control how information is encoded.
| Marks Card Option |
Purpose |
Example |
| Color |
Colors geographic areas based on a measure or dimension. |
Sales by state. |
| Label |
Displays text on geographic areas where labels fit. |
State name or sales value. |
| Detail |
Adds dimensions to define the level of detail. |
State or a suitable geographic identifier. |
| Tooltip |
Displays information when a user hovers over a geographic area. |
Sales, Profit, and State. |
| Color settings |
Controls the palette, range, and appearance of fill colors. |
Sequential colors for sales values. |
Symbol Size is mainly associated with point-based marks. For a standard filled map, color is usually the primary visual encoding.
10. Using Measures to Color Filled Maps
A measure is a quantitative field, such as Sales, Profit, Revenue, or Customer Count. When a measure is placed on Color, Tableau uses its values to determine the color assigned to each geographic area.
Examples
- Sales: Compare sales performance across regions.
- Profit: Identify geographic areas with higher or lower profit.
- Customer Count: Compare the number of customers across areas.
- Revenue Growth: Compare growth across geographic regions.
- Average Order Value: Compare typical order values across regions.
How to Apply a Measure
- Build a filled map using the required geographic field.
- Drag a measure such as Sales to Color on the Marks card.
- Check the aggregation displayed on the field, such as SUM(Sales).
- Review the color legend and its numerical range.
- Adjust the palette and range if needed.
Make sure the aggregation matches the question. For example, SUM(Sales) compares total sales, while AVG(Sales) compares average sales at the displayed level of detail.
11. Using Dimensions to Color Filled Maps
Dimensions contain descriptive or categorical information. A dimension can be used to assign different colors to geographic areas based on categories rather than numerical magnitude.
Example
A company groups its states into sales performance categories: High, Medium, and Low.
| State |
Performance Category |
| Maharashtra |
High |
| Gujarat |
Medium |
| Karnataka |
High |
| Rajasthan |
Low |
| Tamil Nadu |
Medium |
Dragging Performance Category to Color assigns colors to the categories. This is useful for communicating business-defined groups, status, or classifications.
When categorical coloring is used, ensure that the categories are defined consistently and that the legend explains their meaning.
12. Choosing an Appropriate Color Palette
Color selection is important because it determines how easily users can interpret differences between regions.
Common Color Palette Approaches
- Sequential palette: Uses a progression of colors or intensities for values that range from low to high.
- Diverging palette: Uses two contrasting color directions around a meaningful midpoint, such as zero or a target value.
- Categorical palette: Uses distinct colors for separate categories.
Examples
- Use a sequential palette to compare total sales across states.
- Use a diverging palette to distinguish positive and negative profit relative to zero.
- Use a categorical palette to distinguish different business regions or market segments.
How to Change Colors
- Click Color on the Marks card.
- Select Edit Colors.
- Choose a suitable palette.
- Adjust the color range or category assignments as required.
- Confirm that the legend remains readable.
Color Best Practices
- Use a clear palette with sufficient contrast.
- Keep the meaning of colors consistent across related dashboards.
- Use a diverging palette only when a meaningful midpoint exists.
- Do not rely on color alone to communicate critical information.
- Consider users with color-vision deficiencies.
- Always display a clear legend.
13. Displaying Labels on Filled Maps
Labels display text directly on geographic areas. They can show state names, sales values, profit values, or other relevant details.
Steps to Add Labels
- Drag the required field, such as State, to Label on the Marks card.
- Open Label to configure text and visibility.
- Add a measure such as Sales if numerical labels are required.
- Adjust the font size and formatting.
- Review the map for overlapping or unreadable labels.
When to Use Labels
- When the map contains a manageable number of regions.
- When viewers need to identify geographic areas quickly.
- When the labels add meaningful information to the visualization.
Avoid displaying too many labels on a crowded map. Use tooltips for additional information when the geographic areas are too small to accommodate readable text.
14. Configuring Tooltips
Tooltips display additional information when a user hovers over a filled geographic area. They let users explore details without placing every value directly on the map.
Useful Tooltip Fields
- State or Country
- Total Sales
- Total Profit
- Profit Margin
- Number of Orders
- Customer Count
- Selected reporting period
How to Customize Tooltips
- Drag the required fields to Tooltip on the Marks card.
- Click Tooltip to edit its contents.
- Arrange the information in a logical order.
- Use clear field labels and suitable number formatting.
- Hover over several regions to verify that the information is correct.
For example, a tooltip for Maharashtra might display its state name, total sales, total profit, and profit margin. The displayed values should correspond to the current filters and level of detail.
15. Understanding Aggregation in Filled Maps
Aggregation determines how Tableau combines multiple records into a value for each geographic area. Choosing the correct aggregation is essential for accurate geographical analysis.
| Aggregation |
Meaning |
Example |
| SUM |
Adds values together. |
Total sales for each state. |
| AVG |
Calculates the average. |
Average order value by state. |
| MIN |
Returns the minimum value. |
Lowest transaction value by state. |
| MAX |
Returns the maximum value. |
Highest transaction value by state. |
| COUNT |
Counts records or non-null values, depending on the field. |
Number of records by state. |
| COUNTD |
Counts distinct values. |
Number of unique customers by state. |
Before publishing a map, verify whether the measure should be summed, averaged, counted, or calculated as a rate. An incorrect aggregation can lead to misleading conclusions.
16. Filled Maps for Rates and Percentages
Filled maps are especially useful for displaying rates, percentages, and normalized measures across geographic areas. Raw totals can sometimes be misleading because geographic regions differ in population, size, and number of customers.
Example: Customer Conversion Rate
Suppose two states have different numbers of visitors and conversions. Comparing only the number of conversions may not show which state has a stronger conversion rate.
A conversion rate can be calculated as:
Conversion Rate = (Conversions / Visitors) * 100
For example, State A has 1,000 conversions from 10,000 visitors, while State B has 600 conversions from 3,000 visitors.
| State |
Visitors |
Conversions |
Conversion Rate |
| State A |
10000 |
1000 |
10% |
| State B |
3000 |
600 |
20% |
Although State A has more conversions, State B has a higher conversion rate. A filled map using the rate can reveal this difference more clearly than a map showing raw conversion totals.
When comparing regions with different populations or sizes, consider suitable rates or per-capita measures where relevant. Clearly document the denominator and calculation used.
17. Filtering Filled Maps
Filters allow users to focus a filled map on specific records, reporting periods, categories, or geographic regions.
Common Filters
- Country or State
- Year or Order Date
- Product Category
- Customer Segment
- Sales Channel
- Performance Category
How to Add a Filter
- Drag a field such as Order Date or Category to the Filters shelf.
- Select the required values or date range.
- Click OK.
- To expose the filter to users, show the filter control.
- Test the map after changing the filter.
For dashboards, filters can help users investigate one year, product category, or geographic area at a time. Ensure that the map title and tooltips accurately reflect the filtered data.
18. Creating Geographic Hierarchies and Drill-Down Maps
A geographic hierarchy organizes location fields into levels, such as Country, State, and City. It can help users navigate from a broad geographic view to a more detailed level.
Example Hierarchy
Country
└── State/Province
└── City
How to Create a Hierarchy
- In the Data pane, right-click the Country field.
- Select Hierarchy and then Create Hierarchy.
- Name the hierarchy Geographic Location.
- Drag State into the hierarchy.
- Add City if the dataset and analysis support that level.
- Use the hierarchy in the view and drill down as needed.
Filled maps are most appropriate at geographic levels for which Tableau has usable boundaries. City-level analysis may be better represented by a symbol map if individual city points are the intended focus.
19. Creating Filled Maps Using Show Me
Tableau's Show Me panel provides a quick way to choose a suitable visualization based on the selected fields.
Steps
- Select an appropriate geographic dimension in the Data pane, such as State.
- Select a measure such as Sales if the visualization requires quantitative coloring.
- Open Show Me.
- Choose the filled map option when available and suitable for the selected fields.
- Inspect the result and verify that the map shows the expected geographic boundaries.
- Use the Marks card to adjust color, labels, and tooltips.
If the filled map option is unavailable, verify that your selected fields and geographic roles are appropriate. You can also create the map manually by adding a geographic field and selecting Map from the Marks type menu.
20. Creating a Filled Map in a Tableau Dashboard
A filled map can be combined with other worksheets in a dashboard to provide a complete view of regional performance.
Example Dashboard Components
- Filled map showing sales by state.
- KPI displaying total sales.
- Bar chart comparing profit by state.
- Line chart showing sales trends over time.
- Filters for date, category, and region.
Dashboard Creation Steps
- Create and format the filled map worksheet.
- Create supporting charts and KPI worksheets.
- Open a new dashboard.
- Drag the filled map and supporting worksheets onto the dashboard.
- Add relevant filters and configure their scope.
- Configure dashboard actions if users should interact with other charts by selecting a region.
- Review titles, legends, labels, and layout.
- Test the dashboard using different filter selections.
An interactive dashboard can help managers investigate regional patterns and compare geographic performance with other business indicators.
21. Common Filled Map Problems and Solutions
| Problem |
Possible Cause |
Solution |
| No map appears |
The field is not recognized as geographic data. |
Assign the appropriate geographic role and verify the location values. |
| Map displays circles instead of filled areas |
The current mark type is a symbol or circle. |
Change the Marks type to Map or select a suitable filled map through Show Me. |
| Some regions are missing |
Locations are unsupported, misspelled, or ambiguous. |
Review unknown locations, standardize names, and add geographic context. |
| Colors do not change by region |
The measure or dimension has not been added to Color. |
Drag the intended field to Color on the Marks card. |
| Wrong sales values appear |
The aggregation or level of detail is incorrect. |
Check SUM, AVG, COUNT, filters, and the underlying data. |
| Labels overlap |
There is insufficient space for all labels. |
Show fewer labels or use tooltips. |
| Similar regions have confusing colors |
The selected palette has insufficient contrast. |
Choose a clearer palette and verify the legend. |
| Raw totals create misleading comparisons |
Regions differ in population, size, or number of customers. |
Consider an appropriate rate, percentage, or per-capita measure. |
| Custom regions cannot be displayed |
The required boundaries are not available through built-in geocoding. |
Use supported spatial files or another appropriate geographic mapping method. |
22. Practical Project: State-Wise Sales Analysis
Project Objective: Build a filled map to analyze sales and profit across Indian states.
Dataset Fields
- Country
- State
- Sales
- Profit
- Order Date
- Product Category
Project Tasks
- Import the dataset into Tableau.
- Check the data types and geographic roles.
- Create a worksheet named State-Wise Sales Map.
- Add State to the view and verify that Tableau recognizes the geographic boundaries.
- Change the Marks type to Map.
- Drag Sales to Color.
- Choose an appropriate sequential color palette.
- Drag Profit to Tooltip.
- Add a suitable date filter.
- Optionally add Product Category as a filter.
- Check for missing regions and validate the displayed aggregations.
- Create a dashboard containing the map, a total-sales KPI, and a profit comparison chart.
Questions to Answer
- Which states have the highest total sales?
- Which states have the lowest total sales?
- Do high-sales states also generate high profit?
- How does regional performance change by product category?
- How does the map change when the reporting period changes?
- Would a rate or percentage provide a fairer comparison than a raw total?
Expected Learning Outcome
By completing this project, you will learn to build filled maps, apply color encoding, configure tooltips and filters, validate aggregations, and interpret geographical business patterns.
23. Interview Questions and Answers
Q1. What is a filled map in Tableau?
A filled map colors geographic areas, such as states or countries, to represent measures or categories.
Q2. What is another name for a filled map?
A filled map is also commonly called a choropleth map.
Q3. What is the main purpose of a filled map?
It helps users compare data across geographic regions and identify regional patterns.
Q4. How do you create a filled map in Tableau?
Add a recognized geographic field to a worksheet, change the Marks type to Map, and place a measure or dimension on Color.
Q5. What is the difference between a filled map and a symbol map?
A filled map colors geographic areas, while a symbol map uses symbols at geographic points.
Q6. How can you color states based on sales?
Drag Sales to Color on the Marks card of a filled map.
Q7. Can a filled map use categorical data?
Yes. A dimension such as Region or Performance Category can assign colors to geographic areas according to category.
Q8. What is a choropleth map?
A choropleth map represents data across geographic areas using different fill colors or color intensities.
Q9. Why are geographic roles important?
Geographic roles tell Tableau how to interpret location fields and help it identify recognized geographic locations.
Q10. What is the purpose of the Color shelf?
The Color shelf controls the color of marks based on a field or selected formatting options.
Q11. Why might a filled map show circles instead of areas?
The Marks type may be set to a symbol-based type. Change it to Map or choose the filled map option when available.
Q12. When should you use a rate instead of a raw total?
Use a rate when the comparison should account for differences in population, number of customers, visitors, or another relevant denominator.
Q13. What is the purpose of a tooltip?
A tooltip displays additional details when a user hovers over a geographic area.
Q14. What are sequential and diverging color palettes?
A sequential palette represents values from low to high. A diverging palette highlights values on opposite sides of a meaningful midpoint.
Q15. Can filled maps be used in dashboards?
Yes. Filled maps can be combined with charts, KPIs, filters, and dashboard actions for interactive geographical analysis.
Q16. Why might some regions be missing?
The geographic names may be invalid, ambiguous, unsupported, or missing from the dataset.
Q17. What is the role of aggregation in filled maps?
Aggregation determines how Tableau combines records for each geographic area, such as calculating total sales or average order value.
Q18. When is a filled map not the best choice?
It may not be the best choice for individual point locations, highly precise point-level comparisons, or data without usable geographic boundaries.
24. Quick Revision Checklist
- Understand the definition of a filled map.
- Know the meaning of choropleth maps.
- Distinguish filled maps from symbol maps.
- Verify geographic roles before creating the map.
- Choose the appropriate geographic level.
- Change the Marks type to Map when necessary.
- Use Color to represent measures or categories.
- Choose an appropriate color palette.
- Configure labels and tooltips.
- Validate the aggregation and geographic data.
- Use filters to focus the analysis.
- Consider rates or percentages when raw totals are misleading.
- Build dashboards with useful supporting charts.
- Resolve missing locations and other mapping problems.
25. Conclusion
Creating Filled Maps in Tableau is an effective way to analyze geographical patterns and compare performance across regions. By using recognized geographic fields, the Map mark type, appropriate color encoding, labels, tooltips, and filters, users can build clear regional visualizations. Filled maps are particularly useful for comparing sales, profit, percentages, rates, and other aggregated data across countries, states, and supported geographic areas. Correct geographic roles, reliable data, and suitable measures are essential for producing meaningful results.
26. Additional Learning Resources