How to have an average line across a bar chart based on a result from a separate table

[HTC]

Hi,

I would like to have a horizontal average line apear on a bar chart, the average needs to be volume weighted.  I created a formula (sum../sum..) in another table.  Is it possible to have the result of this formula appear as the average line?  I'm using a slicer to adjust the time period so would want the average line to change with the underlying data being selected.

Thanks for your help.

[DS12345 · Accepted solution]

Hi @HTC ,

Have you tried adding the measure as a line value in a combination chart?