Average value possible on line chart Y axis?

[andyor]

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:

[andyor]

That's what I was after Antonio thanks. I never knew about this area

[AntonioM · Accepted solution]

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?

[filippo_fontana]

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]

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)

[filippo_fontana]

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