Cascading control, keeps defaulting to all for single selection

Question

Hi,
I recently had a set up where a cascading control would select a specific id based on another control. Usually there is only one specific id, the control would show "ALL" however I could unclick select all and select the specific id, this would show the id in the control box but it would also show in the legend in the visuals I created as the id. For some reason this has changed and no matter what I do the control box and the parameter output on the visual only show "all". I also have another cascading control based on this control but I figure it's the same issue of not processing a selection correctly.

Answer

Thank you for reaching out to AWS!

The cascading filtering implementation is documented in AWS QuickSight Documentation at [1]:

(Optional) You can limit the values displayed in the control, so they only show values that are valid for what is selected in other controls. This is called a cascading control.

When creating cascading controls, the following limitations apply:

> Cascading controls must be tied to dataset columns from the same dataset.

> The child control must be a dropdown or list control.

> For parameter controls, the child control must be linked to a dataset column.

> For filter controls, the child control must be linked to a filter (instead of showing only specific values).

The parent control must be one of the following:

> A string, integer, or numeric parameter control.

> A string filter control (excluding top-bottom filters).

> A non-aggregated numeric filter control.

> A date filter control (excluding top-bottom filters).

To create a cascading control, do the following:

> Choose Show relevant values only. Note that this option might not be available for all filter control types.

> In the Show relevant values only pane that opens, choose one or more controls from the available list.

> Choose a field to match the value to.

> Choose Update.

There is also a QuickSight Workshop [2] using animated GIFs outlining another example of how to set this up. You can have a look at the GIFs and apply the method to your visual.

I trust this answers your inquiry. Please do not hesitate to contact us if you need further clarification on the information given above.

Reference:

[1] Adding filter controls to analysis sheets - Numeric filters - https://docs.aws.amazon.com/quicksight/latest/user/filter-controls.html#filter-controls-customize-numeric

[2] QuickSight Workshops - Author Workshop - Add Interactivity - Exercise 2 – Cascading filters - https://catalog.workshops.aws/quicksight/en-US/author-workshop/3-add-interactivity/exercises

Cascading control, keeps defaulting to all for single selection

Relevant content