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

TypeStatus
AFavorable
BUnfavorable
CModerate

 

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

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

     

4 Replies

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

  • Fowmy's avatar
    Fowmy
    Super User
    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

     

    • dollarvora's avatar
      dollarvora
      Helper I
      5 years ago

      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 ?

    • dollarvora's avatar
      dollarvora
      Helper I
      5 years ago

      Fowmy 

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