Add a Gauge to a Report (Report Builder and SSRS)
When you want to summarize data in a visual format, you can use a Gauge data region. After you add a Gauge data region to the design surface, you can drag report dataset fields to a data pane on the gauge.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To add a gauge to your report
Create a report or open an existing report.
On the Insert tab, double-click Gauge. The Select Gauge Type dialog box opens.
Select the type of gauge you want to add. Click OK.
Unlike Chart, Gauge has only two types: linear and radial. The available gauges in the Select a Gauge Type dialog box are templates for these two types of gauges. For this reason, you cannot change the gauge type after you add the gauge to your report. You must delete and re-add a gauge to change its type.
If the report has no data source and dataset the Data Source Properties dialog box opens and takes you through the steps to create both. For more information see, Add and Verify a Data Connection or Data Source (Report Builder and SSRS).
If the report has a data source, but no dataset the Dataset Properties dialog box opens and takes you through the steps to create one. For more information, see Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS).
Click the gauge to display the data pane. By default, a gauge has one pointer corresponding to one value. You can add additional pointers.
Add one field from the dataset to the data field drop-zone. You can add only one field. If you want to display multiple fields, you must add additional pointers, one for each field.
Right-click the gauge scale, and select Scale Properties. Type a value for the Minimum and Maximum of the scale. For more information, see Set a Minimum or Maximum on a Gauge (Report Builder and SSRS).