Different Color for a Particular value of a dimension

[alkesh_sharma]

Hyi,

I have created age buckets in the front end based on the basis of due date.

The buckets are like Not Due, 0-30, 30-60, 60-90, etc.

I have used calculated dimension in the bar chart and Sum of invoice value as the expression.

Please find the snapshot of the chart attached.

I want the No-Due bar should have a different color from rest of the bucket bars. for example No dues bars should be of blue color rest to be of Red.

Kindly Help.

[#2]

Hi Alkesh,

as already mentioned before, use expressions' background color and enter the following expression:

=IF(sum("Your expression DUE") < 0, red())

Important is to use an aggregation. Without aggregation it doesn't work.