Forum Discussion

Guilgo's avatar
Guilgo
Regular Visitor
2 years ago
Solved

Need Help for my project

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 ! 

4 Replies