Imagine that you have a table in Tableau and you want to colour each measure based on a condition or want to have different marks at the same time.
![](https://www.thedataschool.co.uk/content/images/2021/05/image-45.png)
When you create a table, Measure Names and Measure Values will populate rows or columns and the marks card, and you will have a table similar to the one in the image.
![](https://www.thedataschool.co.uk/content/images/2021/05/image-38.png)
by adding Measure Values to colour and changing the mark to square you would have something like this:
![](https://www.thedataschool.co.uk/content/images/2021/05/image-39.png)
If you right click in Measure Values for the colour mark and choose Use different legends you can split the colour legends in order to have one for each measure
![](https://www.thedataschool.co.uk/content/images/2021/05/image-40.png)
this doesn't give you much flexibility because its not possible to do conditional formatting for a column or a row, imagine you want to create a condition for the profit ratio like this:
![](https://www.thedataschool.co.uk/content/images/2021/05/image-41.png)
And colour that row based on the condition, the rows for Quantity and YoY sales will be coloured as well based on that criteria.
![](https://www.thedataschool.co.uk/content/images/2021/05/image-42.png)
I have a solution for this problem :)
Instead of using Measure Names on rows or colums if you replace the measure name with a placeholder avg(0) or avg(1) for each of the measures you want to create a Marks shelf, you will be able to create a more flexible table:
![](https://www.thedataschool.co.uk/content/images/2021/05/image-43.png)
Now its just about formatting and renaming the axes (note that I have also swapped between rows and columns to change the layout of the table)
![](https://www.thedataschool.co.uk/content/images/2021/05/image-44.png)
I hope you find this useful!!