Forum Discussion
value change based on conditional formatting
I have gauages chart this visual have percentage value this chart based slicer selection Percentage value if value below 89% its should be red . if value range 90% to 95 % color sho...
lbendlin
Super User
Super UserAnonymous
Timeliness % = SWITCH(
TRUE(),
sum(Data[Timely Updated Fields])/SUM(Data[Total])<0.89,"#F03D06",
sum(Data[Timely Updated Fields])/SUM(Data[Total])>0.95,"Amber",
"Green")