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

7 Comments

  1. How are there 2 operators (=,!=) before the THEN clause? I would have expected the following to work:
    IF [Region Parameter] != ‘ALL’ THEN [Region Parameter] ELSE IFNULL([Region], ‘Null’) END
    but, it does not.

  2. I HAVE APPLIED THIS LOGIC FOR STATE PARAMETER ,THEN IT IS SHOWING ERROR THE FORMULA MUST BE AGGREGATE OR REFER TO ONLY THIS FILED

Comments are closed.