fbpx

How to add an ‘All’ parameter option in Tableau

Posted on

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

  2. 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.

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

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

  7. Hi,
    This article is so helpful , thanks for sharing. I would like to share some information on tableau case statements here, have a look at it; goo.gl/MBiQZk

Comments are closed.