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 should amber above 96 its gree .
i have tired dax function value showing blank .here my dax function
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",
sum(Data[Timely Updated Fields])/SUM(Data[Total])<0.89,"Blue"
)
any idea .
1 Reply
Anonymous
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")
