Forum Discussion
GerbenvdHazel
Helper I
Helper IOne slicer replace other slicers - different queries/columns
Hello, In our database you can fill in the names of employees at three different places. For the data I have to run three different reports. I'm looking for an option to create one slicer which...
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
v-lili6-msft
Community Support
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
GerbenvdHazelHelper I
Helper IIndeed. 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