Conditional Formatting doesn't work because it always summarizes the column

[salomao]

I want to show a green circle whenever the effective_status = ACTIVE.

But it doesn't work correctly if I have a date filter applied.

The value is from a dimension table. There isn't a date field in that table. Only in related tables.

[Anonymous]

Hi @salomao 

When you select a column as the field which the conditional formatting is based on, it is expected to be summarized with a definite aggregation type ("First" in your image) as this will provide only one scalar value for a rule to make the decision. In your second image, the status are all "Active" so whichever aggregation method you choose, the result will always be "Active". 

You said it doesn't work correctly if you have a date filter applied. If the date field is from another table, please check the relationship between two tables. If the cross-filter direction is set incorrectly, the filtering result might be incorrect, leading to the conditionl formatting not working. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Ritaf1983]

Hi @salomao 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly