How to track awards data over time?

HI dankello ,

check below steps

• Load your data into Power BI, ensuring it contains columns for "Student," "Date," and "Award" (Gold, Silver, Bronze, No Award).

• Create a new table to define the weighted values for each award category. This table will be used for assigning numerical values to the awards. Let's call this table "AwardWeights" and define the columns as follows:

  • Award: Gold, Silver, Bronze, No Award
  • Weight: Assign numerical values corresponding to the weight of each award. For example, Gold: 4, Silver: 3, Bronze: 2, No Award: 1.

• Create a relationship between the "Award" column in your main data table and the "Award" column in the "AwardWeights" table.

• Create a measure that calculates the weighted value for each student based on the awarded level. You can use the following DAX formula for the measure, let's call it "Weighted Value":

  java
• Weighted Value = SUMX('MainData', 'AwardWeights'[Weight])

  This measure sums up the weighted values based on the awarded level for each student.

• Create a line chart visual in Power BI. Place the "Date" field on the x-axis and the "Weighted Value" measure on the y-axis.

• Add the "Student" field to the "Legend" or "Group" section of the line chart. This will display separate lines for each student, showing their progress over time.