How to highlight an expression based on another column value?

[#1]

Dear Experts,

We have a scenario like, when we input item#, the bar chart output shows all those vendors supplying this item. But only one vendor can be active at a time. We would like to highlight active vendor in GREEN color and the others should be in 'WHITE' color.

Active/Inactive vendor is controlled by a field 'ASL_COMMENTS'. Only for active suppliers this field will be NULL.

We tried with below expression in the colors tab. But it's not working.

if

(isnull(ASL_COMMENTS), green(),white())

Please advise,

Thanks,

Saravanan

[SergeyMak · Accepted solution]

Try to specify your color condition in YourExpression\Background Color

See an example attached.

[#3]

Hi Sergey,

It's working now. Thanks a lot.

But still have a concern. The color of the line also getting changed along with the bar.

Is is possible to change bar color only without touching the line color?

Thanks,

Saravanan

[SergeyMak]

So you can use two separate expressions:

one for bars and one for lines.

In the second just don't use expression for the background