I was wondering if there was a way to auto populate different controls based on a selection. I understand you can configure a control to “change revelant values” and the pick another control/parameter.
Instead what I am looking for is for the controls to auto popluate no matter what control I choose to update.
For example, suppose I have three controls: ID, Customer Name, City
If I choose ID → Customer Name and PartyID will populate
If I choose Customer Name → ID and PartyID will populate
If I choose Party ID → ID and Customer Name will populate
You can get “bi-directional” cascading behavior by using filter controls and enabling Show relevant values only on each. QuickSight will then auto-populate each dropdown based on whatever other filters are active.
Please refer the below QuickSight documentation and community post this might be helpful for you.