Loading

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

Date de publication: May 17, 2024
Tâche

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

Étapes

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

The workaround described below and available in the sample packaged workbook is 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.

 

Ressources supplémentaires
Create Parameters
Numéro d’article de la base de connaissances

001458476

Pièces jointes

Filter Change.twbx

1170 KB

 
Chargement
Salesforce Help | Article