Cascading filter retains values from previous selection

[Sumitha]

There are two dropdowns with cascading filters. Teacher and Student

1. I select value “A” for Teacher Dropdown. Then selected value “AS” for Student dropdown.
2. Now if I select a different value “B” for Teacher Dropdown, the value “AS” is also displayed in the Student dropdown along with the list of values corresponding to Teacher “B”.
   As the value for Student dropdown is incorrect, the visual does not return any result. If I select the relevant value for Student dropdown, the visual returns result and the value “AS” disappears from the Student dropdown list. Is there a way to avoid the value “AS” from appearing in the Student dropdown list?

[Xclipse]

Hi @Sumitha

Please refer to the below QuickSight community post this might be helpful for you.

Filtering by state and hospital

hi @jotg , Yes we can achieve this by using the concepts in QuickSight like Cascading Filter. It means When you select one filter value then the other filter value is auto select. Please go through the below steps. Here I have two filter one is Segment and another is Customer Name as per your Query Lets if you want to select any State from the State Filter then on The Hospital filter the filter Automatically change on the basilic of State what we put on the State filter. I am doing the Same …

[Giridhar.Prabhu]

Hi @Sumitha

Your assessment is right. I tried this myself and see that when you change the selections in the first cotrol the dependent control’s previous selection is not automatically reset. It is not a good user experience. Currently, I don’t see an option to reset the previous selections.

Please raise this as a Bug with AWS and they should be able to fix this issue.

Regards,
Giri

[Sumitha]

Hi @Giridhar.Prabhu,

Thank you for your response.

I had raised a ticket with the AWS team and they have informed that they are aware of this issue and also have a feature to address this.

Regards,
Sumitha

[Biswajit_1993]

Hi @Sumitha, I understand your concern. The best way to handle this is by enabling the “apply button in the filter”.

Please follow the below scenarios

1. Teacher-Student Dropdown Dependency:

• If you select a value (e.g., “A”) from the Teacher dropdown and click “Apply,” the Student dropdown will automatically update to show only values related to Teacher “A”.

• Similarly, if you select a different Teacher value (e.g., “B”), the Student dropdown will update to reflect only the options related to Teacher “B”.

2. Parent Filter (Single vs. Multi-Value):

• If you select a single-value dropdown for the Teacher filter, only values related to that Teacher selection will be displayed in the Student filter.

• If you select a multi-value dropdown for the Teacher filter, the Student filter will update based on all the Teacher values you’ve selected, this means that if you select two values from the Teacher filter, the Student filter will show the related values accordingly. This is the default behavior of BI tools

Please try this method and share your experience

Thanks & Regards
Biswajit Dash

[Brett]

Hi @Sumitha,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Giridhar.Prabhu]

Hi Brett,

This looked like a bug to me. I had suggested @Sumitha to raise it as a bug with AWS. I suggest you tag this as a bug with AWS as a proactive measure.

Regards,
Giri

[Brett]

Hi @Sumitha,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!