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?

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...