How to Show Maps with Missing Data in Tableau Desktop

In this silent video, you’ll learn how to show data that isn't present in a data set on a map in Tableau.

- - - - - - - - - - - - - -
In the following example, the Countries Belgium and Germany disappear from the view because there is no line with data of these Countries in the data set.

By design, missing data will disappear from the view. In this example, workaround this design by adding Countries with the value 0 in a new Sheet in Excel, and then joining the data with a master table of Countries.
1. In this example, ensure your data source contains a sheet all required countries and Zero (0) values assigned to them
2. For this example, we're adding the data source again a new data source
3. Join both sheets from the data pane using the Country field
4. Build the map view, add the Value from Sheet 2 to Color
5. Drag the Country field from Sheet 1 to Details
- - - - - - - - - - - - - -