topic Change color in Clustered column chart. in DAX Commands and Tips

Change color in Clustered column chart.

VagelisVlachos — Tue, 14 Mar 2023 07:57:35 GMT

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

Re: Change color in Clustered column chart.

VagelisVlachos — Tue, 14 Mar 2023 08:03:14 GMT

Re: Change color in Clustered column chart.

v-zhangti — Thu, 16 Mar 2023 05:34:36 GMT

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.

Re: Change color in Clustered column chart.

Anonymous — Thu, 16 Mar 2023 07:09:03 GMT

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")