GalB
GalB

Reputation: 11

Consistent Color Coding for Organ-Specific Biodistribution Data (column features as function of timepoint)

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.

Sample Dataset Screenshot

Upvotes: 0

Views: 7

Answers (0)

Related Questions