Average Reference / Trend Line - for Multipole LInes on a Chart

Hi asjones ,

Thanks for reaching out.

Here's my sample with dummy data based on your post. Below is the common way to show the sales.

As you can see above, the lines show the sum of sales for Tom and Alex. There's also a slicer for names filtering.

Now if you want the average lines in the chart, you need to add each lines one by one with measures.

average of sales by alex = CALCULATE(AVERAGE('Table'[Sales]),FILTER('Table',[Name]="Alex"))

average of sales by tom = CALCULATE(AVERAGE('Table'[Sales]),FILTER('Table',[Name]="Tom"))

average of sales by alex = CALCULATE(SUM('Table'[Sales]),'Table'[Name]="Alex")

average of sales by tom = CALCULATE(SUM('Table'[Sales]),'Table'[Name]="Tom")

The slicer still works, if you select Alex, the line chart will show the lines only about Alex.

In summary, the common way to show different lines in the line chart is to remove the Legend and create measures to show each of them one by one.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.