Two columns from two tables

[Anonymous]

Hi Power BI Community!

I have two tables with each column of supplier names. I want to used the combination as a slicer.

I want to combine these two but I tried appending and merging. Nothing works as a slicer.

What is the right way to do it?

[amitchandak · Accepted solution]

@Anonymous , You can create new common/bridge table and join with both tables

new table = distinct(union(all(Table1[supplier]), all(Table2[supplier])))

or

distinct(union(distinct(Table1[supplier]), distinct(Table2[supplier])))

refer to my video

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19