Set color in one column using value from another column

[TTPP81]

Hi, I would like to set a condition whereby if the value in "date range' column shows 'within date range', the rating column and true rating outcome will change color depending on whether it is MOD (YELLOW) & SUS (GREEN). May i know how can i achieve this?

[BA_Pete · Accepted solution]

Hi @TTPP81 ,

You can create measures that adjust your formatting, for example:

CondFmt_Rating = 
VAR __timeValue = SELECTEDVALUE(CF_Test_Table[Date Range])
VAR __ratingValue = SELECTEDVALUE(CF_Test_Table[Rating])
RETURN
SWITCH(
    TRUE(),
    __timeValue = "Within" && __ratingValue = "MOD", "#FEC0BF",  // your yellow hex code
    __timeValue = "Within" && __ratingValue = "SUS", "#99E3DD"   // your green hex code
)

CondFmt_TrueRating = 
VAR __timeValue = SELECTEDVALUE(CF_Test_Table[Date Range])
VAR __trueValue = SELECTEDVALUE(CF_Test_Table[True Rating])
RETURN
SWITCH(
    TRUE(),
    __timeValue = "Within" && __trueValue = "MOD", "#FEC0BF",  // your yellow hex code
    __timeValue = "Within" && __trueValue = "SUS", "#99E3DD"   // your green hex code
)

Once you've created the measures, you apply them to the visual using Cell Elements > Series (the column you want to format) > Background Colour (fx) > Field Value > select conditional format measure from dropdown list.

In this example, I get the following output:

Pete