Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using 1 slicer for 2 different Queries

Hi   I need some expertise on this following challenge i am facing.    I have data from 2 different Queries:   Query A: There are 43 columns in total.   Query B: There are 5 columns in to...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hello

    Try creating a dimension table like this:

    Dimension Table = DISTINCT(SELECTCOLUMNS(QueryB,"Benefit-Benefit Country",QueryB[Benefit-Benefit Country]))

    Next, create your relationships as one-to-many:

    39.PNG

    Choose the [Benenfit-Benenfit Country] column as the slicer, when you select a value in it, the slicer will filter the two other tables:

    42.PNG

    I hope this helps.

    Best regards

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hello

Try creating a dimension table like this:

Dimension Table = DISTINCT(SELECTCOLUMNS(QueryB,"Benefit-Benefit Country",QueryB[Benefit-Benefit Country]))

Next, create your relationships as one-to-many:

39.PNG

Choose the [Benenfit-Benenfit Country] column as the slicer, when you select a value in it, the slicer will filter the two other tables:

42.PNG

I hope this helps.

Best regards

Giotto Zhi