Show different colors for dimensions in bar chart.

[fionna51]

Hi,

In my app, one login user may contain multiple organizations, my bar chart x-axis is organization and Y-axis is Rate. We have 100 organizations (Organization ID), when one user log in, he might have 4 (Entity ID) of them. I want to show these 4 organizations different colors from other 96.

I am using below statement in Rate expression background color which is working fine if user only have one organization. When user contains multiple organization, all 100 are showing same color. Please advise.

if( [Organization ID]=[Entity ID],$(cDarkGreen),$(cLightGreen))

[settu_periasamy]

May be try like

=if(WildMatch([Organization ID],Concat(Distinct Chr(39)&[Entity ID]&chr(39),',')),$(cDarkGreen),$(cLightGreen))

[fionna51]

Hi,

Thanks for your help, I got your idea. But seems no luck, this is not working. Even only one Entity this didn't work yet.