KNOWLEDGE BASE

Unable to Drill Down on Individual Members in Hierarchy


Published: 24 May 2013
Last Modified Date: 07 Sep 2020

Issue

Drilling down on an individual member in a hierarchy drills down for all members.

Environment

  • Tableau Desktop
  • Relational data sources

Resolution

Workaround 1

Use Filter Actions. When you use filter actions, a selection on one view in a dashboard can filter the other views on the dashboard.

Workaround 2
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
User-added image

Cause

The ability to drill down for individual dimension members is only available for multidimensional data sources, and is not currently available for relational data sources.
Did this article resolve the issue?