Forum Discussion
Slicer for two data sets
Hello
I have two querys query1 and query2 they both have Area, Shop Name and Shop Ref, I want one slicer to filter on both querys. The two query have sumed fields but for different data.
I setup a thrid query with just the Area,Shop Name and Shop Ref, and added a relationship between query1 to my shop table, but it does not filter the data.
How do I get Query3 to filter Query1 and Query2 at the same time.
Regards
GrahamR99
10 Replies
If you have relationship defined, does the arrow goes from query 3 to query 1 and query 2 in your model? If not, define a relationship between the tables.
You might want to create a single column combining(area,shop name and shop reference) if your have composite key.
If this helps, mark it as a solution
Kudos are nice too
Hello VasTg
Shop Name or Shop Referance are both unique so either one of these should work no need to combine the three columns.
I need more of a description on how to setup the relationship, as it is this that is not working.
Regards
GrahamR99
Refer to this document on how to create a relationship.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Join them either based on shopname or shop reference. Then use the column from query 3 in the slicer.
If this helps mark it as a solution
Kudos are nice too
