Unable to get average based on X-axis

[Ubaid]

Hi, I have used line and stacked column chart in my dashboard, and I have calculated the average seperately for each group but the line in graph is not showing average according to the group values in X-axis, I want straight average line according to each group average , is there any one who can help,

For the refrence I have attached snap shots of the graph

[Ashish_Mathur]

What do you meanby Group?  Show the expected result.

[Ubaid]

There is not such group these are two columns In the x-axis, one is of cities and other is of province In which I have multiple cities against one province, In the visual I have sort the axis as province then city , and I want the average line for each province seperatly.For the refrence I have attached the snapshot of the visual

[Ashish_Mathur · Accepted solution]

Hi,

This should be the measure of the line chart

Measure = calculate([your measure],all(Data[City]))

Hope this helps.