Hello team, can we have the filters showing only the relevant data based on the other filters in quicksight? Lets say I have two sets A and B, when I select an option in A, only the relevant data should show up when In try to filter option B. For example, I have set A as countries with USA and Canada, and my set B has Chicago, Tampa, Toronto. When I filter A by clicking on USA, the filter B should only show the options Chicago and Tampa. Is there a way we can do this as my filters show all the values irrespective of the other filters on the same visual.
Yes you should be able to do this in Quick Sight based on how I am understanding your use case. What you need to do is Quick Sight supports this natively through cascading filter controls.
Edit your city filter control, and enable “Show relevant values only”, then select your country control as the parent. After that, picking USA in the country filter will automatically limit the city dropdown to only Chicago and Tampa.
One thing to note is that both controls must use columns from the same dataset, the child (city) must be a dropdown or list style pulling values from the filter (not “specific values”), and the parent (country) must be a string filter control or a string/integer/numeric parameter control.
You can use the Show relevant values only feature in the Parameter Control. It will ask you the related control. So you set this up for your Parameter Control B and say it is related to Parameter Control A
