Conditional value box based change colors based on string value

[dollarvora]

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 color of the boxes change depending on the status
viz. for Favorable it should change to green, red for unfavorable and yellow for Moderate

I know crds with states by OKViz does something similar but it wouldnt accept string in conditions it only accepts numeric conditions

[Fowmy · Accepted solution]

@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 🙂

Website YouTube  LinkedIn

[dollarvora]

@Fowmy 

Thanks a lot for your solution !
I just figured how to make it look like a box and increase the font sizes !

[dollarvora]

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 ?

[parry2k]

@dollarvora card with states is your friend, just create a measure for conditions and return number value in the measure and use it for conditions.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡