I want to add color to a bar graph.

[Paknanarn23]

I want to add color to the bar graph by entering the Expression background color.

The conditions are If the bar graph shows data for the year, include rgb(30,144,255) and if the graph shows data for the month, enter Rgb(70,130,180) and if the graph shows data for the day, enter rgb(135,206,250)

This is the code that displays the data in a bar graph.

please help me

[Ahidhar]

go to properties>expressions>expand>background color>Definition

if(KCE_MonthYear>=Date(Addmonths(today(0)-1,-1),'YYYY-MM-01'), RGB(135,206,250),

if(KCE_Year>Year(Today(0)-1)-1, RGB(70,130,180),

if(KCE_Year>Year(Today(0)-1)-3,RGB(30,144,255))))