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 article to understand the Data Source and Dataset we used for this SSRS report.

Gauge 11

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

Gauge Properties 1

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.

Change Back Fill Color of a Gauge 2

Format Gauge Shape

Within the SSRS 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.

Change Gauge Frame 3

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.

Format Gauge Frame Fill Color 4

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

Show Gauge Frame Shadow 5

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

Gauge Pointer Properties 6

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

Choose Gauge Pointer Type 7

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.

Format Gauge Pointer Color 8

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.

Format Gauge Pointer Cap 9

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.

Fill Gauge Pointer Cap Color 10

Formatting Range Properties of a Gauge

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

Range Properties 11

Format Range Colors of a Gauges

Once you click the Range Properties.. option, a new window will be opened to format the Range colors of a Radial Gauge in SSRS. 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.

Fill Radial Scale Range 12

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.

Format Gauge Range Borders 13

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.

Format Scale Properties of a Gauge 15

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

Format Gauge Label Fonts 16

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.

Format Gauge Scale Numbers 17

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

Format Gauges in SSRS 18