I am not exactly sure what you're asking - directories are the same as sub-channel? You might want to set up a hierarchy on the dimensions that are related. And sharing your packaged workbook will make it easy to understand.
Couple of things you can do. As Mia suggests - create a hierarchy. Here is a how-to: Drill Down and Hierarchies
Also - if you add all the necessary dimension filters on to your viz - you can set the filter options to show "Only Relevant Values" Cascading Quick Filters in Tableau - The Information Lab
Thanks for this didn't seem to work though ;( I am basically trying to associate the sub channel with the main channel so when I am on the dashboard if I say select one of the main channels it selects all the sub channels associated with that channel only
Would greatly appreciate a sample packaged workbook, or at the very least a screenshot explaining what is happening, and what you'd like the desired result to be. Right now we are taking potshots in the dark based on what we are hearing, not based on what we are seeing.
Some things to consider (again, based on my understanding of what I am hearing, and not what I am seeing) :
- Are you using quickfilters on a dashboard that was brought in when you pulled in the sheets? If you pull in filters based on different sheets into a dashboard, but want those filters to apply to other sheets, you need to change the filter settings to apply to all the necessary worksheets.
- Are you using the hierarchies?
- Do you happen to be using dashboard actions?