Forum Discussion
Color code measure for entire table
Hi all, I have a table that looks like this, with many irrelevant columns between Team and ExceededGoalBy. I want to color code every row based on a calculation from the ExceededGoalBy column. How would I write a measure that I can use for Field Value in the conditional formatting with the following logic: if ExceededGoal <0, then use the color red. Else if >= 0 and <5, use color yellow, else if >= 5 then use green. Can somehow help me figure out how to write this DAX measure?
| Team | RandomColumn1 | RandomColumn2 | ExceededGoalBy |
| 1 | a | hg | 5 |
| 2 | b | d | 12 |
| 3 | d | e | 0 |
| 4 | f | u | 2 |
| 5 | e | r | 7 |
