Gauge Labels

You can add labels to gauges, as shown below, to make them look better:

Here each labels shows in text form what the gauge is measuring

There are two parts to adding labels: getting them to display the correct thing, and - more challengingly - getting them to appear in the right place!

Adding Labels

To add a label to a gauge, just right-click on it:

Right-click on a gauge and choose the menu option shown to add a label to it.

Changing the Position of Labels

The label will appear in the middle of the gauge.  You can change its position either by clicking on it and dragging it, or by setting its properties:

You can drag a label around, or right-click on it to change its properties.

For our example, you can position the label by first changing its properties:

Right-click on a label to show its properties, as here.

You can then tell SSRS where the label should appear, relative to the gauge it sits in:

Here the label will appear 5% of the height of the gauge down from the top of it, and 20% of the width of the gauge in from the left.  By setting the width of the label to 60% of the width of the gauge, it will appear centre justified on the gauge horizontally.

Changing the Text on Labels

You can use the Text: property shown above to get the label to show the item being measured:

Click on the function icon shown to change the text displayed on a label

You can then use the expression builder in the usual way to display the length of each film on the label:

The formula gives the length of a film as (eg) 120 minutes.