If I have a hierarchy of controls, can I make changing one control clear the following controls?

[Esther_Kent]

If I have a hierarchy of controls like company / business-unit / department with drop down lists, can I make it so if the user changes the business-unit drop down choice, it clears (select-all) the child controls (department).

Why? If I have the following data:

Amazon / Retail / Dept 1
Amazon / Retail / Dept 2
Amazon / AWS / Dept 3
Amazon / AWS / Dept 4

If I change business-unit from Retail to AWS, if the department was left as Dept 1 then I get zero matches. I would rather it clear ( or “select-all”) the department control. Or if I change the company, then the business-unit AND department are cleared.

Any tips or guidance greatly appreciated!

Thank you

[David_Wong]

Hi @Esther_Kent,

This is currently a limitation. I believe this is the same issue that was discussed here:

Reset child filter when parent resets

On filters where “show relevant values” is selected. The child filter doesn’t reset when I change the value(s) of the parent filter. The problem is when I change the parent filter my visuals show “No Data” until I manually reset the child. I’m concerned end users won’t know to do that; is there a way I can set the child to automatically reset when the parent filter is changed?