Issue with colors in stacked bar chart

[#1]

Hello Experts,

I have to show values in my dimension with some specific colors. I did that, but in cases where certain accounts dont have certain values. The application is taking default color set at the start and there is a mismatch in my colors.

I have taken each color as a calculated dimension and have given expression as

match

(New_VALUE,'Red') . Can anyone help me out with this issue.

Screen shots have been attached.

[MK_QSL]

Can you share your sample apps please?

[#3]

I got it Manish. I wrote a nested if condition for the expression. And it worked.