Line and Clustered column chart - Mantain Colors even change year slicer

[IZ_JE]

Hello,

Anybody knows how to mantain the colors of the Legend and Columns from the "Line and Clustered column chart", even if we change the "Year" in the slicer?

Below I show how we did the process:

What I need to do is having the Actual_Year, Last_Year, Year-2 per Month and when we change the slicer of the Year, the colors of the Columns should mantain.

First we create a second "Calendar" table (PREVIOUS_DATE) as we show below, with a not active relationship.

Then we create the measure to show the last 3 Years:

And then we create the chart with the following columns:

But when we change to another Year, the colors change too as we see below:

Do you have any solution?

Thank you in advance.

[amitchandak · Accepted solution]

@IZ_JE , Have two columns on axis, no legend, that will allow you conditional formatting. Expand and sort of axis

refer : Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[IZ_JE]

Thank you very much for your reply.

It works perfectly: