Last Modified Date: 11 Aug 2020
- Tableau Desktop
- 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials