Colour coded and parameter driven labels

One of the simplest but still one of my favourite Tableau tricks to add that little bit of extra insight into your visualisations is the ability to colour code your data labels.

Tableau doesn’t allow you to make certain labels go one colour and other labels another colour depending on a variable, so I’m going to show you how to get around it.

Note that this tip also used to apply to tooltips and can still be applied to them, but now you can embed worksheets into tooltips, that is an alternative way to achieve the same thing.

Continue reading “Colour coded and parameter driven labels”

Exporting larger datasets to Excel

Tableau’s ability to Export to Excel is really useful, and has saved me many hours down the years. This functionality is currently still lacking in PowerBi (sorry Jack but you know its true) compared to Tableau.

Quite often you will export your Tableau data to Excel to send somebody an extract of the data, maybe that person doesn’t have Tableau or the data is part of a much bigger piece of work and doesn’t warrant a whole Tableau Workbook getting sent. Sometimes these datasets will be large and can be quite a faff to sort out in Excel once it has exported. So here are a couple of tips to help reduce those woes.

Continue reading “Exporting larger datasets to Excel”

Smarter Wildcard Match Filtering

Tableau method for wildcard filtering using multiple search terms.

Tableau’s Wildcard Match and Custom Value List filters are all well and good but they are limited. Both of them require that your search terms are in the correct order and the Custom Value List makes you click each individual item you want to include. For example, searching for “A4 Paper” would not return the [Product Name] “Paper A4”. This is an especially big problem if your field contains thousands of different values with little or no hierarchy to make your search easier.

This is where this Tableau trick can help. It allows you to search for multiple strings in any order, and Tableau will return a list of all items that contain all of those strings.

Continue reading “Smarter Wildcard Match Filtering”