KNOWLEDGE BASE

Create an OR Condition Between Two Filters


Published: 30 Oct 2020
Last Modified Date: 02 Nov 2020

Question

Create an OR condition between two filters

Environment

  • Tableau Desktop

Answer

As the default filtering in tableau is "AND" when using multiple filters, in order to use OR as a condition, follow the below steps

1. Create parameters for dimension values like Category and subcategory below 
User-added image
User-added image
2. Create a calculation like below:
[Category]=[Parameters].[Category] or [Sub-Category]=[subcat]
3. Drag to Filters and select True

Result
User-added image
Did this article resolve the issue?