Could you walk me through step by step how to create cascade filtering? I read several answers , but still couldn’t apply it. Really frustrating… Also, how can I apply filters to all tabs (same and different data sources)? Thank you, Olga.

Hi @olga1 could you solve your issue? if so, could you also mark the post as solved? BR

Hi @olga1 maybe the following will help. [image] Filtering by state and hospital Question & Answer 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 …

Hi @ErikG , I saw this one, but I think it’s an old version and doesn’t apply anymore. Thanks, Olga.

Hi @olga1 no what @Biswajit_1993 wrote is pretty much what you have to do. BR

Cascade filter:Filters have the option to use “Show only relevant values”. But the filter with relevant values need to be added to the dashboard as well. [Screenshot_2024_0123_233050]

Okay, I can’t find the control option [image]

Add filters to the sheet then you click three dots then you can see the options. [Screenshot_2024_0123_235430]

Thank you! So I can’t do it unless I place the filter on the sheet? so for example, if I pin it to the top?

Yes. If you don’t give the users the ability to change the filter, why using a cascading filter?

I can place the filter on top, but than I don’t have the pencil option

Cascade filtering

Q&A

ErikG January 23, 2024, 6:17am 2

Hi @olga1
maybe the following will help.

Topic		Replies	Views
Filtering by state and hospital Q&A filters , quick-sight	7	2865	September 16, 2024
Cascading filter control Q&A filters , quick-sight , filters-controls-and-parameters	2	2483	May 8, 2023
Connecting two filters together to filter the contents of one filter Q&A analysis , filters , parameters , database , quick-sight , filters-controls-and-parameters , visual , Business-Intelligence-Engineer	5	903	May 3, 2024
Hierarchical dropdown filter Q&A developer , embedding , quick-sight	4	176	April 18, 2024
Quick Sight Filters Q&A developer , quick-sight , dashboard-embed	6	289	February 29, 2024

Cascade filtering

Related topics