Issue linking two tables

[dokat]

Hi,

I have two data tables with below information. I'd like to use them as slicer. How can i link thiese two table since second table has more manufacturers listed than the first one. When i create a relation in  Power Query Editor it doesnt work. All my measures are created using the Region  Manufacturer table and doesnt respond to changes to slicere created using POS Manufacturer table. Is there any work around this?

[amitchandak · Accepted solution]

@dokat , One way is to append these table

Second, create common dimension tables and create join

https://www.seerinteractive.com/blog/join-many-many-power-bi/

[dokat]

@amitchandak I successfully created the bridge table however slicer still doent change matrix tale results.

[dokat]

@amitchandak Thank you for your response. Both tables have different columns. Will it still work?

[dokat]

@amitchandak Thank you for your response. Both tables have different columns. Will it still work?