KNOWLEDGE BASE

Unable to Assign Color to Members Not Currently in Field


Published: 11 Nov 2013
Last Modified Date: 03 Aug 2018

Issue

Unable to assign colors or default colors to members of a field or calculated field that do not currently exist.

For example, if data is filtered out of a view then it will not be possible to assign colors for values that have been filtered on that view.

Or if a calculated field has multiple possible results, but with the current data set only some results are ever returned, then it is not possible to set default colors for the values that do not exist in the data set.

 

Environment

Tableau Desktop

Resolution

Option 1: Set Default Colors

If the values for the dimension still exist in the data set, but are filtered out of a particular view, then it will still be possible to set the default colors. This option will not work for measures.
  1. Right-click the dimension in the data pane, and select Default Properties > Color...
  2. In the Edit Colors dialog, set the desired colors and click OK

Option 2: Make an Unfiltered Sheet

If the values of the measure still exist in the data set, but are filtered out of a particular view, then it will be possible to set the colors on an unfiltered worksheet. Colors will persist even after the unfiltered sheet is deleted.
  1. Create a new worksheet
  2. Drag the measure to Color on the Marks label
  3. On the Marks card, click Color and then Edit Colors...
  4. In the Edit Colors dialog, set the desired colors and click OK

Option 3: Add dummy data

Color assignments will persist in a workbook even after dummy data is removed from the original data source.
  1. Add dummy data to the original data source so that all possible options will be present in Tableau.
  2. Assign colors via one of the two methods above

Cause

The ability to assign colors for values that do not currently exist is not currently built into the product.
Did this article resolve the issue?