Forum Discussion
Helper IOne slicer replace other slicers - different queries/columns
Indeed. There is a relationship.
I think I should go for merging. Was hoping for another option but it doesn't seem to exist in PowerBI.
Thx anyway
Helper IThanks for your reply. For this I can also use the option Merge Queries.
I meaned when there are also connections between table 1 -> table 2 and table 3. Multiple active connections aren't allowed.
DoI have to use Lookup instead of connections?
Community SupportDo you mean that you have created the relationship between these three tables(table 1 -> table 2 and table 3)?
If so, when you do a filter on slicer table1, table2 and table3 will be filtered too.
If not, you could use a dim table Employee and then create the relatinship as Standish provided.
or merge these these tables by Employee ID column.
Regards,
Lin
- GerbenvdHazel
Indeed. There is a relationship.
I think I should go for merging. Was hoping for another option but it doesn't seem to exist in PowerBI.
Thx anyway