This post is most certainly more relevant to Tableau beginners coming from Excel, but advanced Tableau users might still find some value, since the question looks easy but turns out the solution is less than obvious…
As I was presenting a view as a text table, looking much like an Excel spreadsheet, a user asked whether I could color one specific column / measure to make it stand out, the same way you would in Excel in 2 clicks. Namely, how to go from this:
I must admit it took me one hour to find how to do it in Tableau… But once you know, it’s 2 clicks as well, just like Excel:
- Drag the Measure Names pill over the Color Box, while pressing the CTRL key
- Adjust the Colors for each Column / Measure.
Should the Color Legend not be visible, go to menu Analysis / Legends and select Color Legend
- You can even let the end user pick which columns / measures to display by enabling the Quick Filter on the Measure Names
To dwell further in Excel territory and use conditional formatting, to highlight specific values in a long list, you can use the combination of Square mark and color. In this example, the losses are highlighted in red: