Add dropdown filter in quicksight

[FABIOLA_PICHARDO]

Hello.

I need to create cascading filters, however I have read the aws documentation ( Creating cascading filters - Amazon QuickSight) and I have not been able to achieve this, can you have any examples please?

Thanks.

[David_Wong]

Hi @FABIO_COIMBRA_FARIAS,
Does this post help?

Filters shows full data list, but not what is valid based on other filters

When you’re editing your control, there’s a “Show relevant values only” button at the bottom. Click on it to see a list of all other controls on your sheet. You can then select any of those controls to create the dependency. [image]

[FABIOLA_PICHARDO]

Hi @David_Wong

I have applied what you mention in the other ticket, however my 2nd filter that updates the list depending on filter 1 finally does not work because it does not filter if I select an option from list 2 or from the 2nd filter.

I don’t know if I need to apply something else so that when selecting an element from the second list/filter it updates the information of the entire dashboard.

[David_Wong]

Hi @FABIOLA_PICHARDO,

Can you upload some screenshots showing how you created your filters?

[FABIOLA_PICHARDO]

Hi @David_Wong

My first filter :ÁREA
My second filter : UNIDAD

So when I select DESAZOLVES 1 it doesn’t filter the table only with the records that have DESAZOLVES 1, it doesn’t even do anything, it doesn’t update the information in the table:

So, I choose the option “DESAZOLVES 1” and it does not filter me by that data:

Only the record that has DESAZOLVES 1 should appear in the table
Thanks…

[David_Wong]

Can you edit your filter like this and take a screenshot?

[FABIOLA_PICHARDO]

@David_Wong This is filter AREA:

[David_Wong]

Can you show your UNIDAD filter? My understanding is that it’s your UNIDAD filter which isn’t working.

Your AREA filter appears to be working. You selected “Alcantarillado” in your filter and your table is showing the rows that contain “Alcantarillado”.

[FABIOLA_PICHARDO]

@David_Wong

I think that right there is my mistake:
I don’t have UNIT as a filter, it’s only as a parameter/control, so I’m missing something that I don’t know so that UNIT can be filtered and at the same time be nested or a child of the first filter “AREA”

[Niharika]

Hi @FABIOLA_PICHARDO, Can you try the following approach to add UNIT as a filter.

1. Add UNIT data field as a filter.
2. Select ‘custom filter’ from filter types and enable ‘use parameters’.
3. Choose the UNIT parameter that was added as a control to the sheet.
   Now when the parameter control is selected, the data should reflect based on the selection made.
   Here is a link to adding filters to analysis: Adding filters - Amazon QuickSight

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.”