Forum Discussion
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 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.
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
2 Replies
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
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.
