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.
Hi all,
I'm having what I think is a simple problem and can't seem to find a solution. I have two Excel datasets which contain marketing lead data and built them out into a matrix in PowerBI. Each table has an "Asset/Activity" field, and I want to create a slicer which will filter both sets of data. When I try to build a relationship between the two tables on the aformentioned field, I get an error: "You can't create a relationship between these two columns because one of the columns must have unique values"
Any help is appreciated!
Solved! Go to Solution.
You will need to create a lookup table with distinct values to join the fact tables. Then use the lookup table to populate your slicers. It is not difficult and can be completed using the built in query editor. Check this link for more information.
Proud to be a Super User!
You will need to create a lookup table with distinct values to join the fact tables. Then use the lookup table to populate your slicers. It is not difficult and can be completed using the built in query editor. Check this link for more information.
Proud to be a Super User!
You might also be able to create the lookup table using a calculated table and the SUMMARIZE function.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |