Forum Discussion
Dax - Conditional Fomatting
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 thi...
Hi Greg, the rule would be:
IF (Duration (Days) > Average of Duration (Days), "Red", "Green")
Greg_Deckler
Community Champion
Community ChampionSo what is the rule that it should be highlighted?
Hi Greg, the rule would be:
IF (Duration (Days) > Average of Duration (Days), "Red", "Green")
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
Thank you very much Anonymous,
That was exactly what I was needing.