Custom Color Legends Based On Sets Not Retained after Saving Workbook

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


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


Tableau Desktop 10.3.2 - 10.3.4


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.


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?