topic Re: Dax - Conditional Fomatting in DAX Commands and Tips

Dax - Conditional Fomatting

Anonymous — Tue, 17 Mar 2020 12:50:40 GMT

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?

Re: Dax - Conditional Fomatting

Greg_Deckler — Tue, 17 Mar 2020 14:21:27 GMT

So what is the rule that it should be highlighted?

Re: Dax - Conditional Fomatting

Anonymous — Tue, 17 Mar 2020 14:39:16 GMT

Hi Greg, the rule would be:

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

Re: Dax - Conditional Fomatting

Anonymous — Sun, 22 Mar 2020 12:34:20 GMT

Hi there.

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

Here's the file:

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

Best

Re: Dax - Conditional Fomatting

Anonymous — Mon, 23 Mar 2020 14:28:09 GMT

Thank you very much Anonymous,

That was exactly what I was needing.