Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey everyone !
I'm working on a personnal project on PowerBI, the objective is to create a dashboard about Tennis Result, I've already harvested and cleaned the data with Python, I have several data tables :
In my table "Matchs", I have the matches and general info on them, player, winner, tournament, year... (primary key match_id, one row per match_id)
In my table "MatchStats", I have two rows per match_id, one/player, some fields are common and the values are the same (round, tournament, year, field, duration, but I mostly have stats on each player, result of first set, second set etc... number of serves, double faults etc....
I have a page "Players", in which I want to filter on a single player and obtain information about that player, in this page
I want to create an indicator or metric that will return the player(s) against whom the player (the one filtered in the slicer) has won or lost the most.
Either with a card to have the name and the value, or in a table where I'll have as column “Players” and the value next to it and I'll make a top 5 for example.
this page is under construction and looks like this (data not up to date) :
Thank you !
Solved! Go to Solution.
Hi @Guilgo,
I'm attaching a pbix file with my solution.
Proud to be a Super User!
if you have any ideas about my report, ideas for graphs or graphs to import that might match, don't hesitate!
Hi @Guilgo,
I'm attaching a pbix file with my solution.
Proud to be a Super User!
Hi @Guilgo,
Could you share a pbix file so I can take a look?
Proud to be a Super User!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |