Has no-one been able to come up with a solution to this?
Hi All, I finally worked it out.
(Cannot upload workbook from this pc)
Assuming you are using the superstore sample, create a "Location" hierarchy using Region, State, Zip
Drag Location to the columns shelf and sales to the rows shelf to create a bar chart.
Create a dashboard and drag this sheet to it.
To perform the drill-down:
1. Move you cursor over Central, it shall highlight grey)
2. Double-Click so that just Central shall be shown
3. Place your cursor above the 4M mark on the X axis, a small 'plus' icon shall be displayed - click-this
4. Congratulations, you are now drilling into a specific data-set
Just be wary that going back-up isn't as easy as you need to manually clear the filters before drilling-out I am using quickfilters to do this.
This is a great way to drill into your data - thanks for sharing. One limitation is that this only works for vertical bar charts. If displayed as a horizontal bar, the dimensions in the hierarchy simply expand with each layer of drilling which takes up precious real estate.
Ville Tyrväinen has come up with a great approach using action filters, but at this time it doesn't allow for comparison of the children within a hierarchy on the viz itself (e.g. selecting "US" shows the measure for US in the viz > selecting a particular State shows the measure for that State in the viz, etc.) Drill down alternatives
Cripes this thread is old (3.5 years), asked that waay back when I had just started using Tableau, great to see people are still asking and looking into finding new ways to develop the tool to suit.