Add a gauge to a paginated report (Report Builder)

Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools

In a 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.

Add a gauge to your report

1. Create a report or open an existing report.

2. On the Insert tab, double-click Gauge. The Select Gauge Type dialog opens.

3. Select the type of gauge you want to add. Select OK.

   Note

   Unlike charts, gauges have only two types: linear and radial. The available gauges in the Select a Gauge Type dialog are templates for these two types of gauges. For this reason, you can't 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 opens and takes you through the steps to create both. For more information, see Add and verify a data connection (Report Builder).

   If the report has a data source, but no dataset the Dataset Properties dialog opens and takes you through the steps to create one. For more information, see Create a shared dataset or embedded dataset (Report Builder).

4. Select the gauge to display the data pane. By default, a gauge has one pointer corresponding to one value. You can add more pointers.

5. 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 more pointers, one for each field.

   Right-click the gauge scale, and select Scale Properties. Enter a value for the Minimum and Maximum of the scale. For more information, see Set a minimum or maximum on a gauge (Report Builder).

Related content

Nested data regions (Report Builder)
Gauges (Report Builder)