Forum Discussion

justnoob08's avatar
justnoob08
Frequent Visitor
2 years ago
Solved

Dynamic conditional formatting based on values of field

  I'm trying to create a conditional format but it is dynamic based on the row value I'm trying to display this in a matrix with a stoplight analysis, My challenge is that the rule is different for...
Need Help
Show and Tell
Tutorial Requests
  • isjoycewang's avatar
    isjoycewang
    2 years ago

    Hi justnoob08,

     

    Please apply below measure to your table background/font color.

    *Note - I just write several scenario for reference so please remember to write definition for other pages.

     

     

    Color Measure = 
VAR _loadtime = SUM('Table'[LoadTime])
RETURN
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime<3, "Green",
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime >3.99 && _loadtime<11, "Yellow",
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime>12, "Red",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime<5, "Green",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime >5.99 && _loadtime<19, "Yellow",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime>19, "Red",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime<6, "Green",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime>6.99 && _loadtime<24, "Yellow",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime>24, "Red")

     

     

     

    Best Regards,

    Joyce

isjoycewang's avatar
isjoycewang
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi justnoob08,

 

Please apply below measure to your table background/font color.

*Note - I just write several scenario for reference so please remember to write definition for other pages.

 

 

Color Measure = 
VAR _loadtime = SUM('Table'[LoadTime])
RETURN
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime<3, "Green",
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime >3.99 && _loadtime<11, "Yellow",
SELECTEDVALUE('Table'[Page]) = "Homepage" && _loadtime>12, "Red",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime<5, "Green",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime >5.99 && _loadtime<19, "Yellow",
SELECTEDVALUE('Table'[Page]) = "FlightSelect" && _loadtime>19, "Red",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime<6, "Green",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime>6.99 && _loadtime<24, "Yellow",
SELECTEDVALUE('Table'[Page]) = "Guest" && _loadtime>24, "Red")

 

 

 

Best Regards,

Joyce

justnoob08's avatar
justnoob08
Frequent Visitor
2 years ago

Hi, Joyce. 

 

Thank you for the response I was able to confirm this as working. Do you happen to know if I can use the actual stoplight Icons for "Green", "Yellow", "Red" like below?

 

 

  • isjoycewang's avatar
    isjoycewang
    Icon for Solution Supplier rankSolution Supplier
    2 years ago

    Hi justnoob08,

     

    If you want to have a status icon in your table, please consider to create below measure and apply conditional formatting on the font color of it.

    Status = UNICHAR(11044)
// Apply Conditional formatting by field value on [Status Code]