Showing Attendance and Non Attendance

[g1davies]

Hi,

I am trying to create a graph which shows attendance and non attendance of students on their course. I would like to show this as a percentage, broken down weekly from the start of their course for the first 4 weeks, but continuing for 12 weeks or so. I have a list of customers with start and end date fo their course and data for everytime they attend. I have created a mock graph to show what i want it to look like.

The data i have is below and the type of graph I am after is also below, I would be really grateful if anyone could help

Thanks

Gavin

Attendance DataGraphCourse data

[v-lili6-msft]

hi,@g1davies

    You may try to refer to this article:

     https://community.powerbi.com/t5/Desktop/Summarise-duplicate-values-in-a-chart/m-p/506985#M236810

    If not your case, Please share some data sample and the expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin