Change the color of the previous year in a bar chart

[Spotto]

hello everyone, I have a chart that I always compare a month and year with the previous one. I need to create a measure that changes the color of the previous year's bar.
Can anybody help me?
thanks

[Ritaf1983]

Hi @Spotto 
You just need to use a combo of line and clustered chart and put your year in a columns legend:

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

[Spotto]

@Ritaf1983 tks for your help, but dont work. Only a part worked

BEFORE:

AFTER:

In this chart model that suggested the line does not show by month, but the total or the average only

is there a way to fix this?

I will leave the test file below for you
test.pbix 

[Ritaf1983 · Accepted solution]

Hi @Spotto 
Unfortunately, I cannot understand your test file...
From the attached image I understand that the line issue is not a visual issue, you just need to calculate it the right way.
Something like :

Average_Sales =

Var

currentSales = [sales_]

Var

Last_Sales = CALCULATE([sales_],PREVIOUSYEAR('financials'[Date]))

Return

(currentSales+Last_Sales)/2

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