How Do You Map Data in Tableau?
Putting your data on a map turns abstract numbers into a clear, visual story about where your business is succeeding and where opportunities lie. This guide will walk you through exactly how to create insightful and effective maps in Tableau, from preparing your data to building multi-layered visualizations.
Why Visualize Data on a Map?
Before jumping into the “how,” it’s helpful to understand the “why.” When your data has a location component - like customer addresses, store locations, or sales regions - a map can reveal trends that a bar chart or spreadsheet simply can't.
- Identify Geographic Patterns: Instantly see clusters of high-performing regions or underserved areas.
- Understand Spatial Relationships: Analyze how performance in one area might influence another, like the impact of a distribution center on regional sales.
- Improve Storytelling: Maps are incredibly intuitive. Presenting sales data on a map of the United States is often more compelling and easier to understand than showing a table with 50 rows.
Getting Your Data Ready for Tableau Maps
Tableau is smart, but it needs a little help to understand that "California" or "90210" are geographic locations. The key is to assign a Geographic Role to your location-based data fields.
Tableau can automatically recognize place names and geographic codes. In the Data pane on the left side of your workspace, you will find your data fields. If Tableau recognized a field as geographic, it will have a small globe icon next to it. If not, you can assign the role manually.
To assign a geographic role:
- Right-click on the data field (e.g., "City," "State," "Postal Code").
- Hover over Geographic Role.
- Select the appropriate role from the list (e.g., City, State/Province, Country/Region, ZIP Code/Postcode).
The more specific your geographic data is, the better. For example, having separate columns for Country, State, and City will prevent ambiguity errors, such as Tableau not knowing which "Springfield" you mean.
Supported Geographic Roles in Tableau
Tableau's built-in geocoding supports a wide range of roles:
- Airport codes (IATA/ICAO)
- Country / Region
- State / Province
- City
- County
- ZIP Code / Postcode
- Congressional Districts (U.S.)
- CBSA/MSA (U.S.)
How to Create a Simple Map in Tableau (Symbol Map)
A symbol map places a mark (like a circle or square) on the map for each location in your data. It’s perfect for visualizing individual points, like store locations or customer addresses.
Step 1: Place Your Geographic Field on the View
Simply drag and drop a geographic field, like State, from your Data pane onto the center of the worksheet. Tableau will instantly recognize it's a geographic field and create a map view. It automatically generates Latitude (generated) and Longitude (generated) fields and places them on the Rows and Columns shelves.
You’ll now see a map with a single dot on each state where you have data.
Step 2: Add Measures to Give the Map Meaning
The map is a great start, but the dots are all the same. Let’s make them tell a story. Drag a measure, like Sales, from your Data pane onto the Size property on the Marks card. The dots will now change size based on the total sales for that state - the bigger the circle, the higher the sales.
You could also drag the Profit measure to the Color property. Now, not only will the dots show sales volume (by size), but they’ll also show profitability (by color). You can instantly spot large circles (high sales) that are colored orange or red (low profit), highlighting problem areas immediately.
Creating a Filled Map for Regional Analysis
While symbol maps are great for specific locations, filled maps (also called choropleth maps) are better for visualizing data across defined regions, like countries or states. Instead of a dot, the entire region is shaded based on a measure.
Changing Your Mark Type to a Filled Map
- Start with the simple map you created above.
- On the Marks card, click the dropdown menu that currently says "Automatic" (or "Circle").
- Change the Mark Type to Map.
There you go! Your map of the United States will now show each state colored based on the measure you have on the Color property. For example, if you place 'Sales' on Color, states with higher sales will be a darker shade, providing an at-a-glance overview of your top-performing regions.
Adding Layers for a More Detailed View
Tableau’s power really shines when you start adding layers of data to a single map. Imagine seeing states shaded by overall sales, with cities shown as circles sized by profitability. This gives you both high-level and granular insights in one visualization.
This is easily done using Tableau's map layering feature.
Step 1: Create your Base Map
Start by creating a filled map as described above. For this example, let's say you have State on Detail and Sales on Color to create a filled map showing sales by state.
Step 2: Add a Second Geographic Layer
Drag another geographic field, such as City, from the Data source pane directly onto the map. You’ll see a drop zone that says Add a Marks Layer. Drop the City field there. Tableau will add a new set of marks (one for each city) on top of your state-level map. You'll also see a new tab appear on your Marks card, one for each layer (State, City).
Step 3: Customize the New Layer
Select the Marks Card for your new "City" layer. Now you can customize it independently from your "State" layer. For instance:
- Drag the Profit measure onto the Size property to make the city marks bigger or smaller based on profitability.
- Drag the Sales Category dimension onto the Color property to color each city dot based on the best-selling product category in that city.
Now you have a multi-layered, information-rich view showing both regional sales performance and city-level profitability in a single, interactive chart.
Tips for Better Map Visualizations
Creating a map is one thing, creating an effective one is another. Here are a few tips to make your maps clearer and more insightful.
- Use Meaningful Tooltips: Tooltips are the information boxes that pop up when you hover over a mark. Customize them! By default, they show the data used in the view. You can edit the tooltip to include other relevant information, like Profit Ratio, Number of Customers, or top-selling product.
- Choose Colors Wisely: Use a diverging color palette (like red-to-green) when visualizing positive and negative values, such as profit. Use a sequential palette (light-to-dark) for values that range from low to high, like sales.
- Keep it Simple: Don't try to cram too much information onto one map. A map showing 15 different measures using color, size, shape, and text will just confuse your audience. Stick to one or two main ideas per map.
- Use the Zoom: Maps are naturally interactive. Encourage your audience to zoom in on specific regions and use filters to narrow down the data being displayed.
Common Troubleshooting: Unrecognized Locations Error
One of the most common issues users face is a small gray indicator in the bottom-right corner of the map that says "# unknown." This means Tableau couldn't recognize one or more of your locations.
Click on this indicator. Tableau will open a dialog box showing the unrecognized locations. You often have a few options:
- Edit Locations: This is for clear typos or variations (e.g., "U.S.A." instead of "United States"). You can match your unrecognized name to one in Tableau’s known database.
- Filter Data: If the data is simply invalid, you can choose to filter it out of the view entirely.
- Enter Latitude and Longitude: If you know the exact coordinates for an obscure location, you can manually enter them.
The best long-term solution is to clean the underlying data source whenever possible. This ensures that you won't have to fix the same unknown locations every time you refresh your data.
Final Thoughts
As you can see, creating maps in Tableau transforms your location data from static rows into dynamic, interactive visualizations. From simple symbol maps showing store performance to complex, layered maps that provide both macro and micro views of your business, geographic analysis is a powerful tool for finding actionable insights.
While Tableau offers incredible depth, its multi-step process and significant learning curve can be challenging. For teams that need answers fast, we built Graphed to simplify this entire workflow. Instead of dragging and dropping fields, assigning roles, and customizing marks cards, you can just ask in plain English: "Show me a map of total sales by state and add a layer of profit by city for Q4." We connect directly to your data sources and instantly build the interactive map for you, letting your analysis keep up with your curiosity.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.