Conditional formatting not consistent

[FAW71]

I have a table column with the due date in it. I have another column that has a calculated value of "Past Due" or "Due". The due date column has the conditial format set so that if the due indicator is past due, show red, if the due indicator is Due show blue. But it's not working. See below; both records are past due but the due date column is not red for one of them.

[tharunkumarRTK]

@FAW71 

Is there any aggregation applied on "Due Indicator" column after placing it into the table visual? if yes it is "First" or "Last"? if it is last then you need to consider keeping the same type of aggregation in your conditional formatting logic as well. At present from the screenshot that you shared, it seems you applied "First" as aggregation. 

Connect on LinkedIn

Read my blogs here: TechieTips

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[lbendlin]

What's the formula behind the Due Indicator?

Seems to work fine with static fields