Don't set Group A to only relevant values. Only do that on the subsequent filter options. That is the obvious fix you are missing!
You should note that setting too many filters to "Only Relevant values" can impact performance negatively.
Some more relevant info here:
Hi Matt -
But if I don't check the 'only relevant values', I wind up giving the user the choice that renders a completely blank panel; it 'fixes' my users ability to walk up the hierarchy at the cost of giving them a meaningless choice.
If your initial filter selection can result in a blank view, that's no good. I'd need to see a workbook to see exactly why that would be the case. If you can post a .twbx packaged workbook file here, I'll take a look.
My point is that you should use a hierarchical structure. Show all values for the initial filter, and only use the 'relevant values' option when absolutely necessary.
If your initial filter results in a blank view, you can remove values from that list manually by duplicating the field, and creating another filter on the duplicate field--and excluding any values you don't want to show from the original field's quick filter. Note that if you go this route, you WILL have to set that initial field's filter to "only relevant values". An alternative is to set a Data Source filter that completely removes the option from the list--but that affects every sheet in the workbook, so I'm not sure you want that.
I'm attaching a workbook that demonstrates the problem. The key is the first filter, on date worked, effectively masks out values from the second filter, utility. The second filter has a Miscellaneous value that renders something if your date selection value is past three months, but renders a blank page if your selection is current month.
If you play around with only include relevant values, on the second and third filter and then start making choices, you can get to a place where the user is trapped, and loses the ability to see all of their options on the second filter.
Hi Matt -
Sorry for bombarding your inbox!
It looks like adding my first filter to context, then choosing 'all values in context' for my second filter, and only appropriate values for my third filter does the trick!
Thanks to this guy:
for letting me know about this feature. *That* was the simple thing I was missing!
Glad its working! Make sure to mark the question answered in some way so others know your issue is resolved (can mark it assumed answered if you like) Thanks!