Forum Discussion
Solved
Unable to get average based on X-axis
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 i...
Hi,
This should be the measure of the line chart
Measure = calculate([your measure],all(Data[City]))
Hope this helps.
What do you meanby Group? Show the expected result.
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
Hi,
This should be the measure of the line chart
Measure = calculate([your measure],all(Data[City]))
Hope this helps.