Forum Discussion

jake4001's avatar
jake4001
Frequent Visitor
2 years ago

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 wo...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

jake4001 this color measure:

 

Color Measure = 
VAR __Exceeded = SELECTEDVALUE ( Table[Exceeded Goal By] )
RETURN
SWITCH ( TRUE (),
    __Exceeded >= 5, "Green",
    __Exceeded >= 0, "Yellow",
    "Red"
)