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,
I'm building a fixture-type report for a local tennis tournament. Teams will play again each other (10 teams) and I want to visualize the results in a matrix in which I should have the same field in rows and columns to have then the results on each game. I'm confuse on how to build this matrix with the same field. Can you provide any guidance?
Thanks,
Ezequiel
Solved! Go to Solution.
Try splitting that out into a "Home Team"/"Away Team" relationship. Basically, it's a "Many-to-Many" relationship on one field, but that associative entity will have a reference to both teams, plus additional information about the event occuring between those teams. You might need to denormalize into a single table for this using that logic.
https://en.wikipedia.org/wiki/Associative_entity
Try splitting that out into a "Home Team"/"Away Team" relationship. Basically, it's a "Many-to-Many" relationship on one field, but that associative entity will have a reference to both teams, plus additional information about the event occuring between those teams. You might need to denormalize into a single table for this using that logic.
https://en.wikipedia.org/wiki/Associative_entity
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 |