GAUGES in SSRS

Create a GAUGE in SSRS

{Continue with previous}

Step 1: Create a report with new dataset and name it (Myself it was Gauges shown below) and a parameter deptno.

Right click on design window --> insert --> Gauge

Step 2: Choose any one of the gauges-->OK

Step 3:  Now click on pointer --> go to Expression

Step 4:  Write the expression (my self finding department wise Avg salary)-->OK

Step 4:  Go to radial pointer properties and choose options Pointer fill, Cap fill like so.. then OK

Step 6: We can change the radial Scale properties also. Click OK

Step 7: 

For the label values Write the Expression shown below --> ok

Step 7: Select any department then click on preview