Is there a way to add an average line to a "line and clustered column chart"

[Anonymous]

Is there a way to add an average line to a "line and clustered column chart"?  

I tried the solution listed from 2017, and all I get are averages for each bar, not the entire chart.  Is there an easier way?  Is this a feature that will be coming out soon?  This apparently can be done in Tableau but not in PBIx.

Thanks for your help.

[Ritaf1983 · Accepted solution]

Hi @Anonymous

As you mentioned, these types of charts do not have average lines as a generic feature.
But we can add more lines at any time.
Based on the original values of your bars/lines, you can calculate the average using the DAX ALL function.
As an example:

Average of line Part = CALCULATE(average('Table'[Value2]),all('Table'[Category]))

Put it as a new line.
In the attached picture, I have two averages, one for lines, and one for bars:

Link to the sample file 

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