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 Reporting Services with an example.

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

Indicators 12

Format Indicators in SSRS

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

Add Label to Indicators 1

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

Indicator Label Properties 2

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 0

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.

Round Expression 3

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 Indicator Label Fonts 4

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

Change Indicator Type 5

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.

Select Directional Indicators 6

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

SSRS Directional Indicators report Preview 7

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

Format Indicator Icon Colors 8

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

Change Indicator Colors 9

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

Format Indicators 10

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

Add Multiple Indicators 11

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.

Select Ratings Indicator 12

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

Format multiple Indicators 13

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.

Add Indicator to Gauge 13

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

Format Indicators Preview 15