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.

[danextian]

Hi @FAW71 

For all the non-summarized dimensions added to the table visual, there could be more than one vaues of Due Indicator in each row. Have you checked whether both Due and Due Indicator columns are using the same summarizaton?

[v-shchada-msft]

Hi @FAW71,

Thank you for the update. We're glad to hear that the colors are now working correctly.

If you have any more questions in the future, please feel free to create a new post. We're always happy to help.

Thank you.

[FAW71 · Accepted solution]

@tharunkumarRTK & @lbendlin 

I don't know what happen but when I refreshed my data today the colors started working correctly.

[FAW71]

@tharunkumarRTK 
There is nothing applied to the visual, just clean columns.

[FAW71]

@lbendlin 

Here is my past due logic

Due Indicator = 
IF(
    
        'Action Items'[Due].[Date] < TODAY() &&
        'Action Items'[Status] <> "Completed" &&
        'Action Items'[Status] <> "Approved",
        "Past Due",
        "Due"
)

[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