Mixing 2 slicers of 2 different datasets so that they interact as one

[Niels_T]

Hello,

The situation is as followed:

1. We use data of 2 different sources: Magento and Google Analytics

2. I use the value "Users" from Google Analytics and the value "Orders" from Magento 

3. We have 3 different brands and we filter them through a slicer.

The left "Brands" is for Magento the right "Brand" is for Google Analytics. They have the same name and I still have to add the 2 other brands from Google Analytics, so that's why you only see one at the moment.

Is it possible to make those 2 slicers as one, so that when I click on "Brand 1" the data changes for both users and orders, as it looks up from 2 sources?

Best regards,

- N

[amitchandak]

@Niels_T , Create a common brand table from these two and join with both tables

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

refer my video : https://www.youtube.com/watch?v=Bkf35Roman8

[Niels_T]

Hello,

I was able to make a seperate table with only those brand names in it. However, when making the relationship it won't give me the option to do single to many, and this gives some problems.