This sounds like a complex workbook. Could you post it here so we can better understand your fields and filters/parameters?
In the meantime, I'm wondering if you can use the filters you have (Year/Sector), have a sheet that shows responses, and then use an action filter on that sheet to show the chart breakdown by gender.
An example with Superstore data is attached.
ActionFilter.twbx 1.2 MB
I agree a workbook with an example would be helpful to see what you're doing. Here's my guess at what you're attempting, let me know if I got it right.
You're basically looking for a way to get a dynamic filter option based on the sector selected. Using a simple example
We've got two sectors: sports and books
- Sports have improve health and socialize as responses
- Books have de-stress and learning as responses
If you select sports as the option you want to have the options of either improve health or socialize. Likewise books will have the book responses instead of the sport responses.
If that is what you're looking for then here's an option of what you can do.
- Create a string parameter with the sectors as the option values. [Sector Selector]
- Create an IF formula inside a case statement that inputs the [Sector Selector] and outputs a filtered response option. [Response Options]
IF [Sector] = [Sector Selector] THEN [Responses] END
3. Use [Response Options] as the filter with [Sector Selector] visible.
Hopefully this will help get you started.
Below is a sample workbook.
But I've now solved the problem using LODs. I didn't realise that LODs operate at a lower level than context filters.
There's an amazing video by Bethany Lyons that can be accessed from here:
And a summary article here: