How to add an ‘All’ parameter option in Tableau

Ever wanted to include an ‘All’ option in your Tableau parameters? Simple! Here’s how:

  1. Create your parameter with the options available. In this example I’m creating one for [Region]. Make sure to manually add the ‘ALL’ option.
  2. Drag the corresponding field you will be filtering on to the filters shelf
  3. Right click on the field and choose ‘Filter’ then the ‘Condition’ tab
  4. In the ‘By Formula’ radio option on the bottom enter the formula below, replacing my [Region] fields with your own
  5. Revel in your accomplishment

IFNULL([Region],'Null') = IF [Region Parameter] != 'ALL' THEN [Region Parameter] ELSE IFNULL([Region], 'Null') END