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.

     

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, Anonymous 

 select your matrix visual got to visuals formatting apne and select cell element and enble background color like below

 

select fx  it open conditional formatting pane here change format style to rule , and what field should we base this on select your your column using your table name.

and put your rules in condition like below

after these your matrix look like 

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

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
    Resident Rockstar
    2 years ago

    hi, Anonymous 
    provide sample data and what you want.