Line graphs: Overall avg line and multiple avg lines on one graph

[Dunner2020]

I got two tables date and a fact table. The date table contains date-related information whereas the fact table contains information about call handling that includes call handle time in mins and agent-name who handles the call and call date. Now I want to make a visualization where one line graph shows the overall average call handle time each month. I also want to show the average call handle time for each agent. So, I created two measures as follows:

Overall avg time = 

CALCULATE(AVERAGE(Fact_Table[Contact handle time (mins)]),ALLSELECTED(Fact_Table[Agent Name]))

Avg Time by Agent =  AVERAGEX(VALUES(Fact_Table[Agent Name]),  AVERAGE(Fact_Table[Contact handle time (mins)]))

When I show the above measures along with Month Name and Agent Name on the Table visual it works. However, when I tried to plot the same information on a line graph it did not. I put Month Name on the x-axis, and both measures on y-axis, which showed two line graphs. I tried to bring in Agent Name in the legend field, but it did not let me put in. I can only put in Agent-Name in the legend field when there is only one measure on the y-axis field. Is there any way to show these multiple line graphs on same visual?

I want something like as shown below:

Sample data here

[Ashish_Mathur]

Hi,

With 2 measures dragged there, you can drag Agent to either the X-axis or to Small Multiples well.

[Dunner2020]

@Ashish_Mathur , added sample file in the actual post

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the problem there.