Forum Discussion

Ubaid's avatar
Ubaid
Frequent Visitor
4 years ago
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 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

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This should be the measure of the line chart

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

    Hope this helps.

3 Replies

    • Ubaid's avatar
      Ubaid
      Frequent Visitor
      4 years ago

      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's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        This should be the measure of the line chart

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

        Hope this helps.