Forum Discussion

dollarvora's avatar
dollarvora
Helper I
5 years ago
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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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

     

parry2k's avatar
parry2k
Super User
5 years ago

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.⚡