How to use a single slicer to control two different visulizations

[Anonymous]

I have three different herirarichal slicers. Each has a coulmn and semi column on whose basis data is filtered in the graph. 

Now I also have to add a data table to the mix, but the two columns are the common entity amongst the two., As such when I'm trying to create a realtiomship between those two, Power  BI throws an error saying that one or more column needs to unique.

I'm not sure which direction I should be proceeding.

Please help

End Goal: to haver both the table and graph controlled from the same slicers. 

[MFelix · Accepted solution]

Hi @Anonymous,

You need to create a Dimension table with unique ID's from the column that are common to both tables and then make the relationship between the two originals tables trhough this new table.

Regards,

MFelix