Tableau Tip: How to give Measure Values separate legends

by Jonathan Allenby

Earlier this week my fellow DS13 cohortians and I were introduced to the fact you can give different measures their own unique legends on the same chart. This can be applied whenever you have Measure Names on your row or column shelf, and means you can give each measure a different colour palette! It is also vital in order to correctly configure the tooltip in Workout Wednesday W9.2019, so this post will be incredibly valuable if you’re feeling a bit stuck on that challenge.

In this example I’ll be using Tableau’s “Sample – Superstore” data set and working from the below starting point.

Subcategory by Sales and Quantity

I’ve filtered out some of the subcategories just to make it easier to view. My goal is to colour the Sales column and Quantity columns differently.

1. Drag Measure Values onto Color.

If you have a similar table as mine above you should now have a single legend that accounts for all of your measure values. Your whole table will also be colour coded based on this legend.

2. Right-click (or hover over and open the drop down menu for) the Measure Values color pill and select “Use Separate Legends”.

Bam! You should now have two separate colour legends for you to play with! From here you can do some pretty cool things. For example, if you:

1. Swap the mark type to Square.

2. Open up the colour settings for one of your legends.

3. Set the colour to white and the start and end values both to 0.

And now you have a table where only the sales are colour coded. Neat!


Jonathan Allenby

An Introduction to Converting SQL Code to Alteryx &Tableau Prep

6 mins read

Tue 18 Aug 2020

Dashboard Week Day 2: The Perilous Life of Being an Avenger

2 mins read

Thu 25 Apr 2019

Dashboard Week - Day 1: NHS Trust Expenditure

2 mins read

Tue 23 Apr 2019

Tableau Prep: Using "Group & Replace" to catch & fix spelling errors.

2 mins read

Tue 26 Mar 2019