Forum Discussion
Resolver ISlicer for two data sets
Memorable Member
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
GrahamR99Hello 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
- VasTg
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
- GrahamR99
Hello
I trying to make a relasionship with query 2 and I get a error how do I fix or work around?
Regards
GrahamR99