Line Graph to Show Rolling Ons and Roll offs

[HighTower]

Hi

I'm trying to visual data for a project focusing on apprenticeship assessments. The data we have has the start dates of the assessment perods and we know the assessment period is up to 56 days.

I'm struggling to turn this into a line graph to explain when we will experience peaks and troughs as apprentices roll on and off the program given that the assessment is 56 days and not just a single point in time. 

I started off using GANNT but I have too many assessment to make that an effecient way to count the volume of assessments we could have.

TIA

[v-lili6-msft]

hi, @HighTower 

Please post some sample data in copiable format and expected output. It will be really helpful to understand your requirement in detail and to provide an accurate solution.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[HighTower]

Lin,

The simplified data I'm working with looks like this below .  Each apprentice has an ID number, a program start date, end date and the course they're loaded onto. 

If I try turn it into a line graph (below) I get just the point in time the start the course, what i'm trying to achieve is a way of representing the count of apprentices on program at any one point given their start and end dates.

Line graph might not be the right format to do this, I'm open to ideas to represent the values.

quicly modelling it in excel might explain what i'm trying to achieve Looking at row 2, I would expect this to count as 1 apprentice on program between 02/05/19, until row 3 joins on the 22/05/19, then show 5 when row 4 and 5 join on the 25th. 

Does this help or should I try represent it more with the lines or  of data shown below?

[v-lili6-msft · Accepted solution]

hi, @HighTower 

You could try to refer to this post I have solved:

https://community.powerbi.com/t5/Desktop/Track-the-Workload-by-counting-the-number-of-in-progress-ta...

Best Regards,

Lin