Tableau Essentials: Chart Types – Filled Map

Data

Tableau Essentials: Chart Types – Filled Map

Not everyone is a Tableau guru, at least not yet. To help Tableau rookies, we’re starting from square one with the Tableau Essentials blog series. The series is intended to be an easy-to-read reference on the basics of using Tableau Software, particularly Tableau Desktop. Since there are so many cool features to cover in Tableau, the series will include several different posts.

We’ve already covered the other type of map view in the symbol map article. Now, let’s look at the filled map chart type. The filled map is another view ideal for geographic data. Instead of circles or squares to display data points, the filled map uses shading on a country or state basis to indicate relationships. You can control the shading with the Edit Colors option in the Marks card.

Note: Tableau 8.1 was used to create the map images in this blog post. For more on changes to maps in Tableau 8.2, see our post here.

Let’s just review the map navigational tool before we get started:

Nav Tool

This tool has four controls. They are (starting from top to bottom): zoom in, zoom out, zoom into a selected area using a click-and-drag and reset map. For a more controlled zoom in and zoom out, hold CTRL and scroll with your mouse wheel. These controls will help you and your report viewers navigate around your view, particularly if you’ve got a lot of detail spread across the globe. To pan across your map, hold SHIFT and left-click drag your mouse across your screen.

Example: Visualizing Sales Around the World

Sticking with the data source we’ve been exploring in this blog series, let’s say we want to visualize our sales in our store locations across the world. We have a field in our data source which Tableau recognizes as having a geographic role (State). When you double-click on that field, Tableau will automatically generate a map. You might notice a few little hiccups in getting your data to convert into geographic locations. Tableau will alert you by putting a small grey box—the null indicator—in the bottom right-hand corner of your visualization.

Tableau locations unknown

This means you have some locations that Tableau isn’t exactly sure where to place. Clicking on the grey box will bring up a menu:

Special Values for [State] 

Often, our nomenclature in what we are calling a specific state or place doesn’t mesh with Tableau’s. It’s also possible to mix up international data with US states in the same field. Let’s try to fix this problem by first clicking on Edit Locations.

 Edit Locations

There are 100 states that are not matched in Tableau’s State list. As we scroll through the list, we see the reason why Unrecognized is listed—Tableau is looking to match states in the United States (which is selected above for Country). 

Correcting the issues identified by Tableau can be done a couple of ways. If you click on the red text that says Unrecognized you will see a list of states. From this list, you can select the state that matches your data point. This is particularly helpful in doing a little data-clean up in Tableau. You can then change the underlying data source later. In our sample view here, it would make more sense to choose one of two routes to correct the issues. Click on the drop-down option where United States is listed for Country to see the following options:

Country Options 

You can select None, meaning that Tableau will not limit your locations to a particular country. You could also select From field, another field in your data source that contains additional details for the particular location you are trying to plot. With this option, Tableau knows the exact state and country in which you want to display your data. 

I’ll select From field and add the Country/Region field from my data source to clarify where my State data should be displayed.

Click OK, and you’ve fixed the problem! I can now drag Sales to Color, and the Mark Type will automatically change to Filled Map. This quick process gives me the visualization below where higher sales are reflected by darker shades of green:

Filled Map 

Figure 1: Filled map.

There you have it! It’s easy to see how filled map visualizations are one of the funnest views to create in Tableau.

Happy mapping!

Other Chart Types

Here is the complete list of chart types from the Show Me menu. Be sure to check back often as we continue to release new articles in each chart type in this sub-series.

Introduction

  1. Text Table (Crosstab)
  2. Heat Map
  3. Highlight Table
  4. Symbol Map
  5. Filled Map
  6. Pie Chart
  7. Horizontal Bar Chart
  8. Stacked Bar Chart
  9. Side-by-Side Bar Chart
  10. Treemap
  11. Circle View
  12. Side-by-Side Circle View
  13. Line Charts (Continuous & Discrete)
  14. Dual-Line Chart (Non-Synchronized)
  15. Area Charts (Continuous & Discrete)
  16. Scatter Plot
  17. Histogram
  18. Box-and-Whisker Plot
  19. Gantt Chart
  20. Bullet Graph
  21. Packed Bubbles

More Tableau Essentials

Want to learn more about Tableau? We have several posts outlining all of Tableau’s fantastic features. Check out the full list on our Tableau Essentials blog channel.

As always, let us know if you have any questions or comments about this post or Tableau in general. If you’re looking for personalized training or help with something bigger, contact us directly!

Contact Us

Want More Tableau Essentials

  1. Tableau Essentials: Chart Types – Introduction
  2. Tableau Essentials: Chart Types – The Text Table
  3. Tableau Essentials: Chart Types – Heat Map
  4. Tableau Essentials: Chart Types – Highlight Table
  5. Tableau Essentials: Chart Types – Symbol Map
  6. Tableau Essentials: Chart Types – Filled Map
  7. Tableau Essentials: Chart Types – Pie Chart
  8. Tableau Essentials: Chart Types – Horizontal Bar Chart
  9. Tableau Essentials: Chart Types – Stacked Bar Chart
  10. Tableau Essentials: Chart Types – Side-by-Side Bar Chart
  11. Tableau Essentials: Chart Types – Treemap
  12. Tableau Essentials: Chart Types – Circle View
  13. Tableau Essentials: Chart Types – Side-by-Side Circle View
  14. Tableau Essentials: Chart Types – Line Charts (Continuous & Discrete)
  15. Tableau Essentials: Chart Types – Dual-Line Chart (Non-Synchronized)
  16. Tableau Essentials: Chart Types – Area Charts (Continuous & Discrete)
  17. Tableau Essentials: Chart Types – Scatter Plot
  18. Tableau Essentials: Chart Types – Histogram
  19. Tableau Essentials: Chart Types – Box-and-Whisker Plot
  20. Tableau Essentials: Chart Types – Gantt Chart
  21. Tableau Essentials: Chart Types – Bullet Graph
  22. Tableau Essentials: Chart Types – Packed Bubbles
  23. Tableau Essentials: Formatting Tips – Introduction
  24. Tableau Essentials: Formatting Tips – Custom Shapes
  25. Tableau Essentials: Formatting Tips – Labels
  26. Tableau Essentials: Formatting Tips – Color
  27. Tableau Essentials: Formatting Tips – Tooltips
  28. Tableau Essentials: Formatting Tips – Maps
  29. Tableau Essentials: Calculated Fields – Introduction
  30. Tableau Essentials: Calculated Fields – Logical Functions
  31. Tableau Essentials: Calculated Fields – Number Functions
  32. Tableau Essentials: Calculated Fields – Date Functions
  33. Tableau Essentials: Calculated Fields – String Functions
  34. Tableau Essentials: Calculated Fields – Type Conversion
  35. Tableau Essentials: Calculated Fields – Aggregate Functions
  36. Tableau Essentials: Calculated Fields – User Functions

More About the Author

Robert Curtis

Managing Director, APAC
Building Solutions with InterWorks at Corinium’s Data Architecture Conference in Melbourne InterWorks was a proud sponsor of the Data Architecture Conference hosted by Corinium in Melbourne on 21 and 22 June 2023. Hundreds of ...
Virtual Event Recap: Deep Dive of Tableau Parameters For our June Lunch and Learn, we did a deep dive on parameters for our friends across Australia and Singapore. Tableau is the premier ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!