In my first blog I am going to show everyone how to make a coloured table for several measure values which all have a different scale. This is something Chantel taught us how to make and I really liked how it looked so I decided to dedicate my first blog to it. A coloured table is a table combined with a heat map. It not only shows the data but also brings any patterns out to the forefront for people to easily see. Below is the result and then I will show you how to make a coloured table. I am going to show a tutorial for my dataset, but you can change this to match the dataset you have.

The first step is to make the table. This is done by placing Measure Names and Region into Columns and Sub-Category into Rows. When Measure Names is placed onto Columns, the Measure Values Cell will appear on the left. All Measure Values will appear, drag off any values that you would not like. For my example, I only want count of Order ID, sum of Profit and sum of Sales. This is the table set up. Now it’s time to add the values and create the heat map. Below is what the table looks like so far.

To create the heat map, drag Measure Values onto colour and then change the mark from Automatic to Square. If there aren’t any numbers in the table, then drag Measure Values onto Label. This should add the values into the table. Next, the different variables need to be on separate legends so the heat maps can be independent of each other. This is done my right clicking on the Measure Value cell that corresponds to the colour and click ‘use separate legends’. If you would like you can change the colour of each graph you can do so by right clicking on the colours on the side and selecting edit colours.

This is something that I was taught in the first week of Tableau training and I think it is a really cool way of displaying data. As shown at the beginning, here is the result.

I hope you all enjoyed my first blog.