I’ve built a Tableau dashboard with multiple filters including:
- Year Month
- Date
- Leader Department
- Leader Name
- Leader PID
- Leader Title
- Agent Department
- Agent Name
- Agent PID
- Agent Title
The main visualization is a heat map using [Minutes] as the measure, with color encoding based on a diverging scale:
- Red (#FF0000) for values < 100
- Green (#00B050) for higher values
- Midpoint set to 100
I’ve manually set the color scale to:
- Start: 0
- Center: 100
- End: 43,257 (max value across full dataset)
Higher numbers not in solid green:
Issue
When I filter by Leader Name or Leader Department, the heat map colors shift — the highest values in the filtered view appear as pale green or even grayish, instead of solid green. It seems Tableau is recalculating the color scale based on the filtered subset, even though I’ve locked the range.
What I’ve tried
- Fixed the color range manually in “Edit Colors”
- Created a normalized field: ([Minutes] / 43257) * 100
- Added tooltip logic to explain the color thresholds
Question
Is there a way to force Tableau to maintain the fixed color scale across all filter states — especially when filtering by Leader — so that the heat map remains visually consistent?
Bonus
If there’s a way to dynamically show in the tooltip whether a filter is active and remind users of the fixed color logic, I’d love to hear it.
