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.
Format Indicators in SSRS
First, Right-click on the Indicator and select the Add Labels option from the context menu to show the values.
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
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.
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.
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
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
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.
Click Ok to finish changing the Indicator type and preview the report
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
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
Click Ok and go to Preview tab to see the report preview
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
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.
From the below screenshot you can observe that Indicator column is holding two Indicators
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.
Select the required gauge from the list and click Ok. Here we picked a simple gauge