Add a Gauge to a Report (Report Builder and SSRS)
Applies To: SQL Server 2016
In a Reporting Services paginated report, 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.
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 charts, gauges have 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 (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).