Forum Discussion

Icon for Resolver I rank

Resolver 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:

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?

5 Replies

AntonioM
Solution Sage
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
  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
    Solution 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)
andyor
Resolver I
3 years ago
That's what I was after Antonio thanks. I never knew about this area