KNOWLEDGE BASE

How To Apply Multiple Filters To The Same Dimension Simultaneously


Published: 07 Aug 2020
Last Modified Date: 11 Aug 2020

Question

How to apply multiple filters to the same dimension?
 

Environment

  • Tableau Desktop

Answer

  • By design only one filter can be applied to a dimension. However, by duplicating the dimension it is possible to set/apply two filters for the same dimension.

      For example there is a dimension called Product Name in Superstore sample data source. If we would like to figure out product names which include "Printer" but not include "Multifunction". 
             We could set two different filters by following the steps below:
         
           1. Right-click dimension name [Product Name] and select duplicate.
           2. Set the first filter to [Product Name], and set the second filter to [Product Name (copy)]. The dimension name could be changed freely.
               In this case, we would like to use the wildcard filter and configure like this:
                    [Product Name] filter: Wildcard Match, Include Values
                    [Product Name (copy)] filter: Wildcard Match, Only Relevant Values, Exclude Values

            3. By typing "Printer" in the first filter, and typing "Multifunction" in the second filter, we could find the answer.
  • If more than 2 filters are needed, by repeating the above steps and duplicating the third, fourth... dimensions, multiple filters could be applied.
  • Please remember to check [Only Relevant Values] to the duplicated filters so that the result would be the intersection of all filters.
Did this article resolve the issue?