Line chart with multiple axis should not split by legend.

[Snapdrag]

Hello, I am facing issue with multiple axis line chart. I am looking for a solution where second axis in line chart should not get split by legend.

Chart - Line chart

X axis - Month-Year

Y axis1- Total Time

Y axis2 - Average time 

Legend -  Region

In chart below when I select Country as India in filter, I want my chart to show another average line for Country India but currently it even splits the Average time by region(legend). 

 Data is as below:

Month Year	Country	City	Total Time
2023-05	India	Banglore	190
2023-06	India	Banglore	200
2023-07	India	Banglore	10
2023-05	India	Mumbai	9
2023-06	India	Mumbai	10
2023-07	India	Mumbai	10
2023-05	Australia	Sydney	200
2023-06	Australia	Sydney	200
2023-07	Australia	Sydney	180
2023-05	Australia	Melbourne	90
2023-06	Australia	Melbourne	10
2023-07	Australia	Melbourne	20
2023-05	US	Atlanta	50
2023-06	US	Atlanta	50
2023-07	US	Atlanta	40
2023-05	US	Chicago	80
2023-06	US	Chicago	100
2023-07	US	Chicago	120

[Snapdrag]

@Ahmedx @amitchandak @Ritaf1983 @parry2k , requesting you to help on this problem. Thanks in advance

[Snapdrag]

@Ahmedx @amitchandak @Ritaf1983 @parry2k , requesting you to help on this problem. Thanks in advance

[Anonymous]

Hi @Snapdrag ,

Please try this way:
I create a DAX below to calcaulate the average time:

Average Time for Country = 
CALCULATE(
    AVERAGE('Table'[Total Time]),
    ALL('Table'[City]),
    ALLEXCEPT('Table', 'Table'[Country])
)

The results are as follows:

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

[Snapdrag]

I want a trend linefor the average in the same way I have for total but the requirement is that average line should not get split by legend.