How To Assign Background Color And Shape In The Same Cell

KNOWLEDGE BASE

How To Assign Background Color And Shape In The Same Cell

Published: 18 Aug 2020
Last Modified Date: 18 Aug 2020

Question

How to assign background color and shape in the same cell. Example: Assigning a background color and shape to the same cell based on a condition without changing the color of shape.

Environment

Tableau Desktop

Answer

1. Use two ATTR(1) measures beside each other in columns shelf
2. For the first ATTR(1) placeholder use Color calculation on the color shelf for the background color
3. For the second ATTR(1) placeholder use Shape calculation on the Shape shelf and choose a shape
4. Right click on second place holder and select Dual axis
5. Right click the axis and deselect Show Header
6. The Resulting view would look like below
User-added image