Last Modified Date: 07 Sep 2020
- Tableau Desktop
- Relational data sources
Use Filter Actions. When you use filter actions, a selection on one view in a dashboard can filter the other views on the dashboard.
1. Create a set from Category dimension using all values. Name it Category Set
2. Create a calculated field called Expand with the following formula:
if [Set 1] then [Sub-Category] else "" end
3. Add Category and Subcategory to rows with Sales or any other measure on Text
4. Go to Worksheet -> Actions -> Change set values with the below configurations
CauseThe ability to drill down for individual dimension members is only available for multidimensional data sources, and is not currently available for relational data sources.
To voice your support for the inclusion of this feature in a future product release, add your vote to the following related Community Idea: Add hierarchy drill options "One-Column" and "With Filter"
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials