Forum Discussion
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...
hi, Anonymous
follow below step
make mesure for outcomeformatting =var target = 500var clo = SUMX(condifo,condifo[closedpoint])var a = DIVIDE(clo,target)*31var b =7var final = DIVIDE(a,b)return finalcreate mesure for rules for conditional formattingrules = 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 neededgo to formatting measure > select conditional formatting > select background color
select feild value
press ok
you get theseIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos.
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.
Appreciate your support Dangar332