Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used following expression for color coding of bars in bar chart but the 1st and last if condition is not working
if([New Aging]<=1,LightGreen(),if([New Aging]=2,LightGreen(), if([New Aging]=3,Green() , if([New Aging]=4,RGB(255,191,0),if([New Aging]=5,lightred(), if([New Aging]>5, Red()))))))
in above bar chart I want 1st grey bar as per 1st if condition to be lightgreen like bar 2 and remaining 2 grey bars need to be dark red as per last if condition
Please guide me
if([New Aging]<=2,LightGreen(),
if([New Aging]=3,Green() ,
if([New Aging]=4,RGB(255,191,0),
if([New Aging]=5,lightred(),
if([New Aging]>=6, Red()
)))))
still the result is same, no change in color code