Change indicator icons and indicator sets in a paginated report (Report Builder)

Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools

The preconfigured indicators sets that provides for paginated reports might not always depict your data effectively and work well in the delivered report. This topic provides procedures to change the appearance of indicator icons and change the indicator sets to include different, more, or fewer indicator icons.

Options such as colors can be set by using expressions. For more information, see Expressions (Report Builder and SSRS).

To change the color of an indicator icon

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. Click the down arrow in the Color column next to the icon that you want to change and click the color to use, No Color, or More colors.

    Optionally, click the Expression (fx) button to edit an expression that sets the value of the Color option.

    If you clicked More Colors, the Select Color dialog box opens, where you can choose from a wide array of colors. For more information about its options, see Select Color Dialog Box (Report Builder and SSRS). Click OK to close the Select Color dialog box.

  4. Click OK.

To change the icon

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. Click the down arrow next to the icon that you want to change and select a different icon.

    Optionally, click the Expression (fx) button to edit an expression that sets the value of the Icon option.

  4. Click OK.

To use a custom image as an indicator icon

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. Click the down arrow next to the icon that you wan to change and select Image.

  4. In the Select the image source list, click External, Embedded, or Database.

  5. Depending on the source of the image, do the one of the following:

    • To use an image that is stored externally to the report, click Browse and locate the image. The report will include a reference to the image.

    • To use an image that is embedded in the report, click Import and locate the image. The image will be added to the report definition and saved with it.

    • To use an image that is in a database, in the Use this field list. select the field from the list and then in the Use this MIME type list, select the MIME type of the image.

  6. Click OK.

To add an icon to the indicator set

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. Click Add. An indicator is added, using the default icon and the No Color option.

    Configure the indictor to use the icon and color you want. Procedures earlier in this topic describe the steps to do this.

  4. Click OK.

To delete an icon to the indicator set

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. Select the icon to delete, and click Delete.

  4. Click OK.

See Also

Indicators (Report Builder and SSRS)