Convolutions are painful. Especially when you’re looking for some very specific information(often using filters). Wouldn’t you like something that’s functional and easy on the eye?

We’ll now tell you how to create a single column table that doubles as a filter, that is, a ‘single column quick filter’.

Consider the sales dashboard of a multinational company. Let us assume that the consumers of the dashboard would want to filter data based on the ‘Region’ field. Let’s create a frill-free filter to achieve this objective in 8 simple steps:

1. Drag the dimension by which you want to filter, ‘region’ in this case, to the column block.

2. A two-column table, with the second column having the “abc” place holder text, appears.

Two column table

Two column table

 

3. Create a calculated field (named as ‘BlogFilter’ for this example) with only “ “ as formula, and add it to the columns.

Create calculated field

Create calculated field

Add calculated field to columns

Add calculated field to columns

 

 

4. Also add BlogFilter to the text button in the Marks tab. The ‘ abc ‘ place holder text is now gone.

Add to text button in marks tab

Add to text button in marks tab

 

5. Remove the column divider, using formatting tab and hide the column labels.

Remove column divider in format tab

Remove column divider in format tab

 

6. The result will be a single column table without any header. Now drag the worksheet to the required dashboard and edit the title as per your requirement.

7. Enable filter to the column by clicking on the ‘use as filter’ options.

Use as filter

Use as filter

 

8. For the column to be unaffected by external quick filters, select the ‘Ignore Actions’ button.

Single column Quick Filter using Tableau

Single column Quick Filter using Tableau

VOILA!!! The single column quick filter is done.

 

Note: This type of filter can be used in combination with another filter of the same type or a quick filter. But if you are using another quick filter for the same field in the dashboard, then the filter defaults to “all”, but the filtering still happens.

Also, you don’t have the “all” option that quick filters provide for aggregation. You can work around this by selecting all the rows in the field. But, this makes it a bit tedious for fields with a large number of unique values.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com