Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional formatting

Hello,   Is it possible to apply conditional formatting based on (value in card is equal to or less than or greater than measure value)   Example: "Measure" value is dyanmic (usually 1-100) card...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, Anonymous 
    follow below step
    make mesure for outcome

    formatting =
    var target = 500
    var clo = SUMX(condifo,condifo[closedpoint])
    var a = DIVIDE(clo,target)*31
    var b =7
    var final = DIVIDE(a,b)
    return final
     
    create mesure for rules for conditional formatting
    rules = SWITCH(TRUE(),
    condifo[formatting]<0.5,"#FF0000",
    condifo[formatting]<0.7,"#FFFF00",
    condifo[formatting]<0.9,"#FFA500",
    condifo[formatting]<1,"#90EE90",
    condifo[formatting]>1.2,"#00FF00")
     
    create table visuals or you can change if another needed

     

    go to formatting measure > select conditional formatting > select background color

     

    select feild value

     

    press ok 
    you get these

     

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Dangar332 

 

Thank you for your response. I tried the option you provided & it works well for static rule.

 

However, in our scenario, this rule values needs to be changed everyday as the target for the day changes as **Target = 100/31 days multiplied by today***.

 

Please advise a best way to achieve this 🙂

 

Kudos

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Anonymous 
provide sample data and what you want.