Gauges Report in SSRS

The Gauge data region is a one-dimensional data region that displays a single value in your dataset. An individual gauge is always positioned inside a gauge panel, where we can add child or adjacent gauges. We can use the gauge panel to create multiple gauges inside a single gauge panel that share common functions such as filtering, grouping, or sorting.

We can use gauges to perform many tasks in a report:

Ø  Display key performance indicators (KPIs) in a single radial or linear gauge.

Ø  Place a gauge inside a table or matrix to illustrate values inside each cell.

Ø  Use multiple gauges in a single gauge panel to compare data between fields.

There are two types of gauges: radial and linear. The following illustration shows the basic elements of a single radial gauge in the gauge panel.

Step by Step creating Gauge report

Create data source connection

Create new data set. User this query. I am using AdventureWorksDW2008R2 database.

select p.EnglishProductName, Sum(SalesAmount)as [Total sales] from FactInternetSales f Inner join DimProduct p on P.ProductKey=f.ProductKey Group by  p.EnglishProductName

Report design we take table

In next column we are inserting Gauge.

Select the Gauge type. There are two type of Gauge

Ø  Redail

Ø  Linear

Here I am selecting Redial

Select Gauge data set Values.

Select the Gauge properties.

Write the Gauge name if you want to set the tool tip give the value for it.

Now select Gauge scale properties.

Here you can set the scale value and interval. You can also define the layout and action, Major and minor tick marks, borders etc.

Now view in browser. You will get this report.