Using 1 slicer for 2 different Queries

[Anonymous]

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 total

What i need is to use one slicer to pick up data from both these Queries. 

I mananged to establish a relationship between these 2 Queries with the "Benefit-Benefit Country" coloumn that is present in both the Queries in the hopes that my data gets pulled out by Slicer but unfortunately nothing. 

Kindly assist.

Thanks. 

[v-gizhi-msft · Accepted solution]

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:

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

I hope this helps.

Best regards

Giotto Zhi

[BA_Pete]

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.