After replacing a data source in Tableau, colors that were previously defined revert to the default color palette.
Issues with unexpected formatting behaviors can occur replacing data sources in Tableau Desktop, although many have been resolved.
When a Tableau calculated field with custom colors already exists in the new data source, the colors are preserved when the data source is replaced. If the calculated field does not yet exist in the new data source, it will automatically be copied over when you replace the data source, but the colors will revert to default.
Manually copy the calculated fields over to the new data source before replacing the data source to preserve the colors:
1. Add the new data source.
2. Copy and paste the calculations, groups, and set fields to the new data source.
3. Right-click and replace the old data source with the new one.
Various updates to Tableau Desktop have been completed. Please ensure you are using the latest supported version to have all the most recent software updates. Tableau Desktop versions and downloads are available from the Release Notes page.
If you continue to experience the loss of the custom color palette after replacing the data source, please contact Tableau Technical Support for assistance.
Discuss and vote on the Salesforce Idea to Stop Changing Filters & Colors When Replacing Data Source.
001473911

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.