Dax - Conditional Fomatting

[Anonymous]

Hello people,

I have doubts about how to create a dax function that changes only with month \ year, to highlight in the table only the tickets that were above the average month \ year.

In this screen printed below, the month of March had three tickets resolved that totaled 25.95 days and an average of 8.65 days per ticket.

In the table, only the 1st ticket lasting 12.21 days should be colored.

Is there a way to do this?

[Greg_Deckler]

So what is the rule that it should be highlighted?

[Anonymous · Accepted solution]

Hi Greg, the rule would be:

IF (Duration (Days) > Average of Duration (Days), "Red", "Green")

[Anonymous]

Hi there.

Here's your solution. Please adjust it to your needs.

Conditional Formatting based on Monthly Avg

Here's the file:

https://1drv.ms/u/s!ApyQEauTSLtOgYM_8lY01MNux79mvw?e=LOxfiX

Best

D

[Anonymous]

Thank you very much @Anonymous,

That was exactly what I was needing.