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, Newby with databases and PowerBI. I was creating a table with Horse racing results and everything went well until one horse finally showed up again under the results table. I have two tables, one called Horse Results, and another called Picks. I checked the relationship properties, based on some other comments, I believe I have it as many-to-many with cross filter direction as "both". Probably is something is easy to fix..thanks of the input.
Solved! Go to Solution.
@vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.
do you need a many to many relatioship? where are you filtering the data from in your visuals, you shouln'dt use the both option unless you know how it works
Proud to be a Super User!
@vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.
do you need a many to many relatioship? where are you filtering the data from in your visuals, you shouln'dt use the both option unless you know how it works
Proud to be a Super User!
Yes, that's what I thought...thanks!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |