Hierarchical dropdown filter

[vinodkumarb]

Hi Team
can any one help me on how to create Hieratical dropdown filter in quicksight
example
i have a columns like
1.country
2.state
3 .city

please check below image

thanks
b vinod kumar

[ErikG]

Hi @vinodkumarb
you cant. But you can create three cascading filter instead.
BR

[vinodkumarb]

Hi @ErikG
thanks for quick reply
can you please guide me how we can create cascading filter
or
provide me any video link

thanks
b vinod kumar

[ErikG]

Hi @vinodkumarb

Here is a sample.

Cascading filter - selected filter value persists

I am creating a visual with two filters. I have created a cascaded filter wherein the 2nd filter’s value should refresh based on first filter’s selected value. However, it does not happen always. I have created the below analysis for reference on issue I am facing https://community.amazonquicksight.com#Arena-dashboardId=f2d55589-7ff4-45c6-a6c3-21fe56a469ec&authorId=CU-11778 To reproduce: I have 2 filters → ‘Pillar’ and ‘Audit’. Audit 1 - Audit 8 are applicable to Pillar1, Audit9 - Audit19 are…

You need to create controls, use dataset fields as values and set “show relevant values only”.

BR

[vinodkumarb]

Hi @ErikG

Can you please share me any video link for how to create cascading filter step by step

Regards,
b vinod kumar