Forum Discussion
Solved
Conditional value box based change colors based on string value
Hi I've a dataset as under Type Status A Favorable B Unfavorable C Moderate I was wodering if there was a way to have 3 value boxes for each of the "Type" where the col...
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 🙂
Fowmy
Thanks a lot for your solution !
I just figured how to make it look like a box and increase the font sizes !