Change color in Clustered column chart.

[VagelisVlachos]

In a clustered column chart i have for season 2023 the year 2022 and year 2023 that the revenue will fall in 2023 and  for every year i have the weeks.i want to change the color in this year and the year before in a single clustered column chart.

i have this measure that i made it to put it in the conditional formating in the field value but i get 1 color for 2022 and 2023.

WeeksBeforeCurrentYear =

VAR SelectedYear = MIN('BI_ReservationHeader'[resday])

RETURN

    IF(YEAR(TODAY()) >  SelectedYear, "#D6D600", "#BC1000")

Can anybody help please.

thank you

[v-zhangti · Accepted solution]

Hi, @VagelisVlachos 

You can try the following methods.
Sample data:

Date Table:

Measure:

WeeksBeforeCurrentYear = 
VAR SelectedYear = SELECTEDVALUE('Date'[Year])
RETURN
IF(YEAR(TODAY()) >  SelectedYear, "#D6D600", "#BC1000")

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[VagelisVlachos]

[aditya0125]

use this dax and put the measure into default color as field value.

Week/Months Be4 Currt yr =

VAR S_Year = SELECTEDVALUE('calender'[Date])

return

IF(YEAR(TODAY()) >  S_Year, "#B3EE11", "#BC1000")