Unable to Assign Stable Colors for Dynamic groups
Published: 23 Jan 2018
Last Modified Date: 14 Oct 2019
IssueWhen assigning colors to dimension members, and the dimension members change, then the new members are automatically assigned new colors from the default palette.
For example, when using a parameter value to create dynamic group names, then the colors assigned to each group will change when the parameter value changes.
Manually assign the color for every possible dimension member. For example, if the group names change depending on the value of the parameter, then change the parameter value, assign the desired colors, and repeat for all possible values of the parameter.
Create a calculated field that does not change values to use on Color on the Marks card.
For example, do not include the parameter value in the name of the headers. As another example, when creating a view of the top 5 customers by sales, create a calculation that ranks customers to use on Color rather than using the customer name on Color.
CauseBecause there is so much flexibility in how calculations and views can be created, Tableau Desktop does not assume that similar dimension members should be assigned the same color. This allows for the use case when very similar dimension members should be assigned different colors.