Conditional formatting not consistent

What's the formula behind the Due Indicator?

Seems to work fine with static fields

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 

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 
There is nothing applied to the visual, just clean columns.

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.

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?