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

  • Nina

    Fabulous, thanks!

  • Mark

    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.

  • Mark

    Nevermind the previous comment, I misread the syntax.

  • BABU

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

    • Amol

      Did you found any workaround for the error?
      I am getting the same error message.
      Thanks

  • Travis

Free 5 Day Video Course | Tableau Quick Start

Everything you need to become dangerous :)

x