Row colour based on condition

[Anonymous]

Need your help-

In the attached file i have created details tabluar chart-

I want to mark colour based on some condition-

1. If the  Resolution time is greater than KPI time then mark it RED

2. if the resolution time less than KPI time then mark it green

3. NO -SLA- keept it Green

[Anonymous]

I have noticed the change but where have you done it.

I have requested to change on DSLA sheet.Please help

[Anonymous]

In DSLA Sheet there is a table Box ,

and one more thing the field you are  showing as KPI Time Should be of same format as Resolution time or else we should convert in this form 'HH:MM:SS' and we can  apply it.

Can u please give me correct info , i can try and help.

Thanks ,

Bunny

[petter · Accepted solution]

Recreate your TableBox and make a StraightTable instead: letting every field including DT2 become Dimensions and make the rest into Expressions. Then you can use the "Background Color" property of the Expression for the "Resolution Time" have an If() as expression to give the right background color: