One Slicer to control 2 Pivot Tables with different data source

[Dokat]

Hi,

I have 2 pivot tables with different data sources and i am trying to control pvt tables with one slicer. I used power query to add the tables to data model. My issue is i cant connect 2 tables in power pivot as it doesnt let me create many to many relations. Did anyone come across a similar issue and solve for it.

Thank you

 

[Dokat]

Yes i did place the code in thisworkbook module...strange that its not finding any slicer cache as i am able to make selections on one of the pivot table with the slicer. I just cant connect to the other one.