Power BI line and clustered column chart

@Laura Hill
going to need to understand what you are trying to display in order to help.

what does the line represent? what does the column represent? what data and how are they related?

@Laura Hill
so the line (average) is average of YTD giving of the last 4 years? not average giving of the respective year?

Today is 6/18 for example, is your average cash the average cash of all gifts from 1/1/20-6/18/20, 1/1/21-6/18/21, 1/1/22-6/18/22, 1/1/23-6/18/23 or is your average = average cash of 1/1/20-12/31/23

Did you use measure? or calcuated column? Measure is going to take the filtering context (not sure if i'm saying this correctly), so a chart that has year on the X axis, your normal average measure will be average of gifts for that year.

@Laura Hill
what you are trying to do is not familiar to me on building various visualizations.

I don't know if there are other Power BI expert that's wiling to chrime in, but I think you will not want to use a measure in this case, (or maybe measure that does not take “date filter” into context consideration).

Meaning, create a calculated column in the date table that puts the 4 year average as a column for all date.

Last 4 Full FY Average =

VAR TY = YEAR(TODAY())

VAR TYm1 = CALCULATE([Cash], FILTER('Date Table', [Year]=TY-1))

VAR TYm2 = CALCULATE([Cash], FILTER('Date Table', [Year]=TY-2))

VAR TYm3 = CALCULATE([Cash], FILTER('Date Table', [Year]=TY-3))

VAR TYm4 = CALCULATE([Cash], FILTER('Date Table', [Year]=TY-4))

RETURN (TYm1+TYm2+TYm3+TYm4)/4

my giving data is year based, you can change the above to FY.

then create a separate line chart that has transparent background on top of the bar chart.

This is LIKELY not the best way to do this though.