Quicksight - feature request/question for Filter

Question & Answer
1

Hi,

Please find question description as below:

I’ve created one visual and added several filters. [Filter A and Filter B]

Instruction:
Filter A - includes 2 programs [program1, program2]
Filter B - includes different tasks under the relevant programs [ 2tasks (Task1 and Task2) under program1, 2tasks (Task3 and Task4) under program2]

While I select “program1” from filter A, I’d want only Task1 and Task2 showcased under filter B, the rest tasks hided.
While I select “program2” from filter A, I’d want only Task3 and Task4 showcased under filter B, the rest tasks hided.

Is that possible and how can I achieve? Can anyone share some good practice?

Thanks a lot :slight_smile:

2

Hi @liu_weiwei You can use cascading filters to do this. There’s an example in the workshop that uses Region and Subregion (exercise 2). The values you get in filter 2 will be only those relevant for the data you have in filter 1.

3

Hi @Steph Thanks a lot for your kind suggestion! It works :slight_smile:

4

Hi @liu_weiwei I’m glad that helped. I’m marking the answer as solution. Thanks for taking the time to ask the question in the QuickSight Community :slight_smile: