Last Modified Date: 09 Feb 2022
Environment
- Tableau Desktop.
Answer
Step 1: Create a Parameter
- Click the down arrow next to Dimensions in the data pane and select Create Parameter…
- In the Create Parameter dialog, do the following and click OK:
- Name the parameter [Activate the category filter?]
- For Data Type, choose Integer.
- For Allowable values, select List
- Add two options to the list: 0 for "Deactivate" and "1" for activate
- Right-click [Activate the category filter?] in the data pane and select Show Parameter Control.
Step 2: Create the following Calculated fields
- Select Analysis > Create Calculated Field...
CASE [Activate the category filter ?] WHEN 0 THEN NULL WHEN 1 THEN [Category] END
Step 3: Enable the Activate Filter calculated field
- Drag [Category Filter Controller] to the Filters shelf.
- In the Filter dialog, check an option being displayed and click OK.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials