Tour de france poule data !!!help!!!!

[Krijgerss21]

Hello i need some help for creating a tour de france poule data.  we want to do a tour de france poule this year with some co-workers and we want to show it in a dashboard the scores everybody at each race can somebody help me with this to make it as a good excel format so i can use everybody prediction in a dashboard with points etc.

in the excel sheet screenshot i placed is a list how people can fill the poule 

so everybody makes their own team they score there points by the way the runnes finish 

anyone a idea to makes this in a way so i can make it as a dashboard so people can see and compete agaisnt each other

many thanks

[v-yangliu-msft · Accepted solution]

Hi  @Krijgerss21 ,

In Excel, you can create a table to store the predictions made by each participant. You can then use a formula to calculate the score for each participant based on the actual results of the contest. Once the scores are available, you can create a chart to visualize the scores for each participant. You can also use conditional formatting to highlight the winners of each match.

In Power BI, you can create a data model to store the predictions made by each participant as well as the actual results of the contest. You can then use the DAX formula to calculate the score for each participant based on the actual results of the contest. Once the scores are available, you can create a report to visualize the scores for each participant. You can also use conditional formatting to highlight the winners of each match.

For example, Power BI.

I created some data:

Here are the steps you can follow：

1. You can use the Clustered column chart to see the scores of each player in each game visually..

2. Create measure.

To see the fastest runners in each race:

Rank =
RANKX(
    FILTER(ALL('Table'),'Table'[race]=MAX('Table'[race])),CALCULATE(SUM('Table'[Score])),,ASC)

Flag =
IF(
    [Rank]=MINX(FILTER(ALL('Table'),'Table'[race]=MAX('Table'[race])),[Rank]),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly