KNOWLEDGE BASE

Custom Color Legends Based On Sets Not Retained after Saving Workbook


Published: 07 Sep 2017
Last Modified Date: 10 Nov 2017

Issue

When you save, close and reopen a workbook, the custom color palette is lost. 

The custom color palette is related to a calculated field based on a set, for example:
If <Set> then <field> else "OTHER" END

Environment

Tableau Desktop 10.3.2 - 10.3.4

Resolution

Option 1: 

Upgrade to Tableau Desktop 10.3.5, 10.4.1 or a newer version. For more information, see Upgrade Tableau Desktop.

Option 2: 

If you are unable to upgrade, use one of the following workarounds:
  • Remove the set from the calculated field.
  • Update the calculation to return numbers instead of strings.

Cause

This behavior is related to a known issue with ID 687812 which has been corrected in more recent versions.
Did this article resolve the issue?