Learning curve

Hi, Syndicate_Admin 

According to your description, I think the output can be achieved using the line chart in the Power BI, you can follow the steps:

This is my test data based on your description:

I created a line chart and place it like this:

As we can see, the line in the chart can display the value [Productivity] of each person from the month they joined.

You can also go to the “Format”->X axis to set the start date and end date of the line chart manually based on your requirement, like this:

To get the Average line, you can to to the ”Anakytics” to add an average line, like this:

You can also create a measure to get the dynamic average of each month, like this:

Average =

CALCULATE(AVERAGE('Table'[Productivity]),FILTER(ALL('Table'),[Date]=MAX([Date])))

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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