Filtering visuals using slicer that contains string from a different table

Hello,

I have two tables - a table with a Project List and a table with a Stakeholder register and each stakeholder is aligned with multiple projects. On the stakeholder dashboard I'm trying to use a slicer with just the Project name to filter some stakeholder visuals however I'm unable to create a correct relationship between the two tables to enable this.

Table 1: Project list

Table 2: Stakeholder register

I have tried the extracting values to new rows as the Project name is a SharePoint list and creating a many to one relationship between the two tables. While this works - I've also got issues as this duplicates stakeholders which messes up with the count of stakeholders etc.

I have also tried using a filter measure: https://community.fabric.microsoft.com/t5/Desktop/Multiple-Contains-Filters-using-Visual-Filters/m-p/2669753 however while this works for data tables I'm unable to apply it with other visuals such as column graphs, card visuals etc. 

Is there a way to either generate a relationship between these two tables so the slicer works, or is there a filter measure I can apply to other visuals?

Thanks!