How to filter between two data set in one sheet?

Question & Answer
1

Hi,Guys

How you doing well.

i would like to use filter control dashboard such as Product type = Travel,Health,CI
and i have two data sets.

a. data set 1 have column product_type = Travel,Health,CI
b. data set 2 have column product_type = Travel,Health,CI

My question is how to set up filter product type to filter data set in 1 sheet and can select product type by end user.

Many thanks for your help.
Siriphon.

2

Hi @Siriphon

While creating the filter please select “Applied to All Applicable Visuals” and ensure column names are same across the datasets . This will enable QuickSight to apply the filter on the same column across visuals ( in same Sheet) based on different datasets.

image

Thanks
Vinod

2 Likes
3

Hi @apjvinod .

Many thanks for your help.