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

BA_Pete's avatar
BA_Pete
Super User
6 years ago

Hi there,

 

Have you tried creating a dimension table for the Benefit-Benefit (B-B) countries?

- Create a new table containing only the unique B-B values and load to the model.

- Remove relationship between your two original tables

- Add two new relationships from your new dimension table to the two original tables

- Dimension side should be 'one', fact table sides should be 'many', filter direction from dimension to fact

- Now use you new dimension table to populate the slicer. This should filter both queries on the one slicer.