Forum Discussion

andyor's avatar
andyor
Icon for Resolver I rankResolver I
3 years ago
Solved

Average value possible on line chart Y axis?

Any way of getting in an average value of all the values in my line chart?   My current graph is like this     And I want to include a horizontal line average like this:    
Need Help
  • AntonioM's avatar
    AntonioM
    3 years ago

    Hi andyor 

     

    You can add an average line from the analytics pane in the visualisations tab

     

     

    Which would then give you this

     

     

    Is that what you're after?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello! I can say that it works for a simple graph but if you use small multiples (let's say that you have two values) then the average line will be calculated for total value of the two multiples: you will see the same average on both small multiples graphs... 

AntonioM's avatar
AntonioM
Icon for Solution Sage rankSolution Sage
2 years ago

So then you would need a measure to calculate an average.

 

For something simple like this:

 

 

and using 'type' as your small multiple

 

 

Average = CALCULATE(AVERAGE('Table'[Value]), ALL('Table'[Day]))

 

That gives you two different average lines (5 and 15 in my example)

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, a measure is the solution! My issue is that I need to have an average of a complex measure, which basically is the cumulated value of a table field up to the date. Transactions are positive and negative and you see the cumulated value go up and down.. And I need the average of that cumulated value! I'm geting crazy to obtain it...