KNOWLEDGE BASE

How To Apply The Same Filter With And Without Context To Different Sheets using Sets to show relevant values


Published: 09 Dec 2023
Last Modified Date: 12 Dec 2023

Question

How to apply the same filter with and without context to different sheets using sets to show relevant values.

Environment

  • Tableau Desktop 2023.3

Answer

1. Create a Set.
User-added image
2. Create a calculated field.
User-added imageUser-added image
3. Drag the field into the filter card in sheet 1 and select Ture.
4. Duplicate the field, drag the field into the filter card of sheet 2, and select Ture.
User-added image
5. Right-click the duplicated field in sheet 2 and convert it to the context filter.
User-added image
6. Add the two sheets to the dashboard, and show the Set of relevant values in the context.
User-added image

See the attached file.
Did this article resolve the issue?