Colour Conditions in Tableau

by Seffana Mohamed-Ajaz

For this topic, I will be using the Makeover Monday ’19 Week 1 NHL dataset.


I had produced a very simple dashboard that compares the Home Attendance and Road Attendance for every NHL team, filtering by each season. The chart shown in my dashboard is a butterfly chart, if you would like to know how to produce a butterfly chart then click here.


Image 1 – Dashboard on Makeover Monday ’19 W1 filtered on Season 2001-02.


With my viz, I wanted to show, by colour, which teams had exceeded (or not) Road Attendance over Home Attendance.


How do you do this?


Firstly, the chart will look like Image 2.


Image 2 – Butterfly chart comparing NHL Road Attendance and Home Attendance.


To make the Road Attendance side of the chart change colour, create a calculated field and type as follows in Image 3.


Image 3 – Colour condition calculated field entry.


This calculated field is simply assigning corresponding string values to when you meet either [fixed road attendance] > [fixed home attendance] or [fixed road attendance] < [fixed home attendance].

The calculated field will appear in the Dimensions section in the Data pane. Drag and drop the field into Colour in the SUM([Road Attendance]) Marks card.


Image 4 – Drag the colour condition calculated field into Colour in the Marks card.

Your Road Attendance side of the chart should now change colours according to the calculated field.


Image 5 – Final outcome.


Seffana Mohamed-Ajaz

Fri 01 Mar 2019

Thu 28 Feb 2019

Wed 27 Feb 2019