Forum Discussion

hansolo's avatar
hansolo
Icon for Helper I rankHelper I
10 years ago

Reference Line as Average of Measure

I have a line chart which charts a measure, Price Per Person, over months. I want to add a reference line to the line chart as the AVERAGE of the Price Per Person measure.

 

Any tips?

 

Thank you,

 

 

- dave

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    What's your formula for Price per Person? Is it a sum of prices that you just have split up on your line chart by putting Person in the legend box? Or is it already some sort of average itself?

     

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    hansolo

     

    If you scenario is as Khouseman stated, is a sum of prices that you just have split up on your line chart by putting Person in the legend box, and you'd like to add an average of the Price per person measure, as far as I know it is not possible in a line chart. 

    The task can be easy in a line and clustered column chart.

    AVG = SUM(Table[Price])/DISTINCTCOUNT(Table[Person])



    If you have any question, feel free to let me know.