Formatting Gauges in SSRS

In this article, we will show you how to Change the Gauge color, Gauge Frame, Gauge Pointers, and formatting Range properties in SSRS or SQL Server Reporting Services with an example.

To explain the available SSRS Gauges Format options, We are going to use below shown report. Please refer to Gauges in SSRS article to understand the Data Source and Dataset we used for this SSRS report.

FORMATTING GAUGES IN SSRS 2014

Formatting Gauges in SSRS Properties

First, Right-click on the Gauge will open the context menu, as shown in the below screenshot. Please select the Gauge Properties.. option from that menu

Formatting Gauges in SSRS 2014

Format SSRS Gauge color (Dial Color)

Once you click the Gauge Properties.. option, a new window will be opened to format the Radial Gauges. From the below screenshot, you can observe that, By default, Gauge filled with White Smoke color, but For now, we selected the white color. Please click on the fx button to write the custom expression for color.

Formatting Gauges in SSRS 2014

Format Gauge Shape in SSRS

Within the Radial Gauge Properties window, If you click on the Frame Tab, we have multiple shapes to choose as shown below. Here we stick to the default Circular 2, but you try your own.

Formatting Gauges in SSRS 2014

Format Frame Color of a Gauge

If you click on the Frame Fill Tab, we have the default Frame color, and please change SSRS Gauge frame as per your requirement. Here we are selecting Cornflower Blue color as Frame Color.

Formatting Gauges in SSRS 2014

If you want to set the shadow effects to the Gauge Frame, then please provide the details in Frame Shadow Tab

Formatting Gauges in SSRS 2014

Formatting Gauge Pointer in SSRS

First, Right-click on the Gauge Pointer opens the context menu as shown in the below screenshot. Please select the Pointer Properties.. option from that menu

Formatting Gauges in SSRS 2014

Changing Gauge Pointer

Once you click the Pointer Properties.. option, a new window will be opened to format the Radial Gauge Pointer. Please change the Pointer type and Needle style as per your requirement. In this example, We are changing the Needle Style to Stealth Arrow, as shown in below screenshot

Formatting Gauges in SSRS 2014

Format Pointer Color of a Gauge

Within the Radial Pointer Properties tab, If you click on the Pointer Fill Tab we have the default pointer color and Style, Please change as per your need.

Here we are selecting a Primary color to Blue and Secondary color to Cornflower Blue color.

Formatting Gauges in SSRS 2014

Format Pointer Cap of a Gauge

Within the Radial Pointer Properties tab, If you click on the Cap Options Tab, we have the options to Hide the Pointer Cap and change the default Cap Style, Please change accordingly. Here we are selecting Flattened with wide indentation as the Pointer Cap Style.

Formatting Gauges in SSRS 2014

Format Cap Color of a Gauge in SSRS

Within the Radial Pointer Properties tab, If you click on the Cap Fill Tab we have the default cap color, Please change as per your requirement. Here we are selecting Cornflower Blue color.

Formatting Gauges in SSRS 2014

Formatting Range Properties of a Gauge

First, Right-click on the Range and select the Range Properties.. option from it

Formatting Gauges in SSRS 2014

Format Range Colors of a Gauges in SSRS

Once you click the Range Properties.. option, a new window will be opened to format the Range of a Radial Gauge. First, goto Fill tab, you can notice the default colors and styles of a Range, Please change as per your requirement.

Here we are selecting a Primary color as Light Steel Blue and Secondary color to Cornflower Blue color as shown below screenshot.

Formatting Gauges in SSRS 2014

NOTE: By clicking the fx you can customize the colors using Expression

Format Range Borders in SSRS Gauges

Within the Radial Pointer Properties tab, If you click on the Border Tab, we have the default Line Style, Line Width, and Line Color. Here we are selecting Cornflower Blue color as Line Color, Width, as 2pt shown below.

Formatting Gauges in SSRS 2014

Format Scale Properties of a Gauge

First, Right-click on the Scale will open the context menu. Please select the Scale Properties.. option from it. Once you click the Scale Properties.. option, a new window will open to format the Scale of a Radial Gauge. 

First, go to the Labels tab, you notice the default configurations of a label. Here you can Hide or Show the labels and also change the positions etc.

Formatting Gauges in SSRS 2014

Changing Font Style and Font Size in Gauge in SSRS

Within the Radial Scale Properties window, goto Label Font tab and style the font as per your requirements. In this example, we are changing the Font to Lucida Sans, style to Bold and Color to Black

Formatting Gauges in SSRS 2014

Formatting Scale Numbers in SSRS Gauges

Within the Numbers Tab, you can change the Number format to Number or Currency or Percentage. In this example, we are removing extra decimals.

Formatting Gauges in SSRS 2014

Click Ok to finish formatting the Gauges. Let us see the report preview by clicking Preview tab.

Format SSRS Gauges