Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |