Reputation: 11
Hi,
I'm trying to implement a consistent color coding for organ-specific biodistribution data across multiple sheets in Tableau. My dataset is structured such that each organ is represented by its own column (e.g.,
Bladder %Id/Cm^3, Heart %Id/Cm^3, etc...), and I'm using their corresponding Measure Values fields to include all organ-specific data in visualizations through the column shelf, as a function of time, seperated by synonym.
What I’d like to achieve:
Each organ's line graph/ scatter circle/ etc... (e.g., Bladder, Brain, Heart, etc.) should always have the same color across all sheets and visualizations. I’ve considered using a Preferences.tps file to define a custom palette for these organ-specific colors, but I’m open to alternative approaches if they’re easier or more reliable.
Here’s what I’ve done so far:
1.Created the following Preferences.tps file:
<preferences>
<workbook>
<color-palette name="BiodistributionOrganColors" type="regular">
<color>#FFD700</color> <!-- Bladder: Yellow -->
<color>#FFB6C1</color> <!-- Brain: Light Pink -->
<color>#FF8C00</color> <!-- Dose Injected: Orange -->
<color>#FFA07A</color> <!-- Femur: Light Salmon -->
<color>#FF0000</color> <!-- Heart: Red -->
<color>#8B4513</color> <!-- Intestine: SaddleBrown -->
<color>#FFD700</color> <!-- Kidneys: Yellow -->
<color>#1E90FF</color> <!-- Knee: DodgerBlue -->
<color>#20B2AA</color> <!-- Liver: Light SeaGreen -->
<color>#87CEEB</color> <!-- Lungs: SkyBlue -->
<color>#FFC0CB</color> <!-- Muscle: Pink -->
<color>#228B22</color> <!-- Spleen: ForestGreen -->
<color>#9370DB</color> <!-- Stomach: Medium Purple -->
</color-palette>
</workbook>
</preferences>
2.Saved this file in My Tableau Repository and restarted Tableau.
3.Attempted to apply this custom palette to the Measure Names field using the Edit Colors menu.
The Problem: The custom palette (BiodistributionOrganColors) does not appear in the dropdown menu in Tableau. Tableau defaults to built-in palettes such as Tableau 10 or Tableau 20, and I cannot enforce consistent colors across sheets.
Questions:
Is the Preferences.tps file set up correctly for use with Measure Names? Is there a way to ensure consistent colors across all sheets, even for Measure Names? Are there any limitations to using Preferences.tps with Measure Names/ Values? Is there an alternative approach to defining consistent color coding that doesn’t rely on the Preferences.tps file?
**To help clarify the issue, I’ve attached a sample dataset screenshot that simulates my real data. Any advice or suggestions would be greatly appreciated! Thank you in advance.
Upvotes: 0
Views: 7