Dependent filter on another filter

[andreab]

Hi,
in my dataset, I have these two fields:

• Sector
• Subsector

These fields are related, meaning that each sector is associated with only certain subsectors.

I would like to set up a dynamic filter directly in the analysis so that the “Subsector” filter displays only the subsectors associated with the sectors I select.

So, in the analysis, I want to have:

1. A Sector filter where I can select more than one sector.
2. A Subsector filter that dynamically shows only the subsectors linked to the selected sectors.

Is this possible?

[Giridhar.Prabhu]

Hi @andreab

Yes. It is possible to show only those Subsectors that are linked to a Sector in the Parameter Control.

Please refer to the following documentation

Using a control with a parameter in Amazon QuickSight - Amazon QuickSight

This is the section in the documentation that talks about it

Regards,
Giri