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 report.
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
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.
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.
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.
If you want to set the shadow effects to the Gauge Frame, then please provide the details in Frame Shadow Tab
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
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
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 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 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 Range Properties of a Gauge
First, Right-click on the Range and select the Range Properties.. option from it
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.
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 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.
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 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.
Click Ok to finish formatting the Gauges. Let us see the report preview by clicking Preview tab.
