Format Indicators in SSRS

In this article, we will show you how to Format Indicators in SSRS. It includes adding labels, change the Indicator Colors, Icons, Indicators type, adding multiple indicators, and adding gauges in SQL Server Reporting Services with an example.

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

Format Indicators in SSRS 1

Format Indicators in SSRS

First, Right-click on the Indicator and select the Add Labels option from the context menu to show the values.

Format Indicators in SSRS 2

Now, Let us configure (or Change) the Text produced by the label. First, right-click on the Text will open the context menu. Please select the Label Properties.. option from that menu

Format Indicators in SSRS 3

Once you click the Label Properties.. option, a new window will be opened to format the labels. From the below screenshot, you can observe that By default, it is displaying Text as Label. So, please click on the fx button to write the custom expression.

Format Indicators in SSRS 4

Once you click on the fx button, a new window called Expression will open with available functions. Here, we are displaying the value as Sales of Year to Date – Sales of last year and also rounded the value using Round function.

Format Indicators in SSRS 5

Click Ok to finish configuring custom Expression as label Text

Change Font Style and Font Size of an Indicator Label in SSRS

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

Format Indicators in SSRS 6

Change Indicator Type in SSRS

SSRS allows us to change or format the Indicator type even after creating the Indicator. First, select the Indicator, and right-click on it will open the context menu. Please select the Change Indicator Type… option from the context menu

Formatting Indicators in SSRS 7

Once you select the Change Indicator Type… option, it will open a new window called Select Indicator Type. Use this to select required Indicators (Directional, Symbols, Shapes, and Ratings) from the available once. In this example, we are selecting Simple Directional Indicator, as shown in the below screenshot.

Formatting Indicators in SSRS 8

Click Ok to finish changing the Indicator type and preview the report

Formatting Indicators in SSRS 9

Format the Indicator Color and Icons in SSRS

SSRS allows us to change the Indicator Icons and colors, as well. For this, Right Click on the Indicator will open the context menu. Please select the Indicator Properties option to configure the indicator values. First, go to the Values and State tab, you can notice the default Icons and colors for the indicators.

Please change the Indicator Color and Indicator Icons

Formatting Indicators in SSRS 10

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

From the below screenshot, you can observe that We changed the Color and Indicators

Formatting Indicators in SSRS 11

Click Ok and go to Preview tab to see the report preview

Formatting Indicators in SSRS 12

Multiple Indicators

We can also add multiple indicators into one column. Right-click on the column will open the context menu, and from that menu, Please select the Add Indicator o

Formatting Indicators in SSRS 13

Once you select the Change Indicator Type… option, it opens Select Indicator Type window to select required Indicators (Directional, Symbols, Shapes, and Ratings). In this example, we are selecting Simple Rating Indicator.

Formatting Indicators in SSRS 14

From the below screenshot you can observe that Indicator column is holding two Indicators

Formatting Indicators in SSRS 15

Add Gauge along with SSRS Indicator

First, select the Indicator and Right Click on the Indicator will open the context menu. Please select the Gauge Panel option and then select Add gauge from it. Once you choose the Add gauge option, a new window will open to select the gauge.

Formatting Indicators in SSRS 16

Select the required gauge from the list and click Ok. Here we picked a simple gauge

Formatting Indicators in SSRS 17