How can I set color of pointer in Sharepoint Gauge


https://www.nevron.com/Forum/Topic9597.aspx
Print Topic | Close Window

By Steve Murray - 8 Years Ago
I am using the following code in the pointer to determine the position of the pointer.  Can I also set the color of the pointer based on a text value in this expression? 
Example:=If(FIRST(Fields!HIL)="Caution",10,IF(FIRST(Fields!HIL)="Extreme Caution",30,IF(FIRST(Fields!HIL)="Danger",50,IF(FIRST(Fields!HIL)="Extreme Danger",70,IF(FIRST(Fields!HIL)="Stop Working",90,0))

The above code works fine for setting the pointer correctly on the gauge.  Can I also set the color of the pointer depending on Fields!HIL= Status?

Thanks in advance
...Steve
By Nevron Support - 8 Years Ago
Steve, you can achieve your requirement either by using custom code, or by using expression for the pointer appearance.

Solution with expressions: Simple State Custom Gauge
Take a look at the Pointers -> Appearance tab. The Fill Style of the pointer is specified with the following expression:
=IF(TONUM(Params!GaugeValue.STR) =0, "#868689", IF(TONUM(Params!GaugeValue.STR) <=20, "#E32119", IF(TONUM(Params!GaugeValue.STR) <=40, "#F08A00", IF(TONUM(Params!GaugeValue.STR) <=60, "#FDC844", IF(TONUM(Params!GaugeValue.STR) <=80,  "#89BA17", "#007770")))))

Hopefully this helps.