Forum Discussion
Conditional value box based change colors based on string value
dollarvora
You can create a measure to assign as conditional formatting as follows and choose Field Value then the CF measure.CF = var _status = SELECTEDVALUE(T10[Status]) return SWITCH( _status, "Favorable", "Green", "UnFavorable", "Red", "Moderate", "Yellow" )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
dollarvora
You can create a measure to assign as conditional formatting as follows and choose Field Value then the CF measure.
CF =
var _status = SELECTEDVALUE(T10[Status]) return
SWITCH(
_status,
"Favorable", "Green",
"UnFavorable", "Red",
"Moderate", "Yellow"
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Hi Fowmy ,
Thanks for your reply, but it seems like I can only conditionally format fields in a table and not in a vaue box,
Also, how do I increase the size of the cell if I were to use it as a table ?