KNOWLEDGE BASE

How to Change the Word "(All)" on the Top of the Filter to Other Words


Published: 15 Apr 2022
Last Modified Date: 18 Apr 2022

Question

How to change the word "(All)" on the top of the filter to other words.
Please check the image below.
User-added image

Environment

  • Tableau Desktop

Answer

The ability to change the "(All)" word on the top of the filter to other words, is not currently built into Tableau Desktop.

Please consider this workaround: Using a Parameter as a filter.
The steps are as follows:

1. Make a filter like the below image which adds an "All Items" selection.
User-added image

2. Create a calculation field as a filter. 
[Segment]=[Segment Filter] OR  [Segment Filter]="All Items"

3. Add this calculation to [Filters] shelf and set the "True" value.

4. Right-click the parameter in Step1 and select "Show Parameter".

Now the "(All)" word can be replaced by any word you want like the below image.
User-added image

Limitation of the above workaround:
Only one value can be selected in a parameter, so if you wish to specify multiple items, you will need to set them up in advance in parameters items and filter formulas.
Example: Add the item "Consumer and Corporate" in the parameter.

Please also check the attached workbook for details.
 
Did this article resolve the issue?