Tableau: creating interactive colour legends

by Nora-Ann Weststrate

There are often situations when a dashboard needs to be completely interactive. Using a colour legend assigned to a specific chart represents the colours you use, but it is often necessary to dig in deeper without necessarily using the chart to isolate a specific category. As an illustration, I’ll be using the superstore dataset available on Tableau.

A normal colour legend only enables highlighting of the chart to which it belongs (figure below). it is possible to create an interactive colour legend as a filter over the whole dashboard which enables the user to dig deeper into his/her data.

By creating an additional sheet to use as a colour-legend, it is possible to create an interactive colour-legend.

  • Place the dimension in question in the ‘Columns’ pane (for this example: the ‘Category’ dimension).
  • Create a calculated field with a value of 1.
  • Using the average of the newly created field, place it in the columns pane, next to the dimension.
  • Change the axis of the bar so it is fixed between 0 and 1 and remove the axis header.

  • Place the dimension used for the colour legend (Category) in the colour mark and increase the size of the bar to its maximum.
  • Place the same dimension on the label mark to label each of the colours.
  • Hide the field labels and headers for the columns and centre-align the labels.

  • Create the dashboard with all the required sheets (including the newly created colour legend) and close the automatically generated colour legend.
  • Resize your new colour legend as required. Select the new colour legend and select Fit -> Entire width.
  • Under the same menu select the ‘Use as filter option’.

Congratulations! You now have an interactive colour legend. Using the same concept, it is possible to create any type and any format colour legend you require for your dashboard.


Nora-Ann Weststrate

Reflections of 4 months in The Data School (DS8)

3 mins read

Wed 30 May 2018

Tableau: Using a parameter to change between sheets on a dashboard

3 mins read

Tue 15 May 2018

Alteryx – The Cross-Tab tool – Amazing when knowing how to use it!

2 mins read

Thu 26 Apr 2018

Tableau: creating filter-dependent images

3 mins read

Tue 24 Apr 2018