Set and configure measurement units in a paginated report (Report Builder)

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

In a paginated report, indicators use one of two measurement units: percentage or numeric.

By default, indicators are configured to use percentages as the measurement unit. This means that the indicator values assigned to each icon in the indicator set are determined by a percentage range. The percentage ranges are evenly divided across the icons in the indicator set. Each icon represents an indicator state. You can change the percentages for each icon in the indicator set by specifying different start and end percentages. Indicators also automatically detect the minimum and maximum values in the data.

You can change the measurement unit to be a numeric value. In this case, you do not specify minimum or maximum for the data; instead, you provide only the start and end values for each icon that the indicator uses.

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

To use the numeric state measurement unit

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

2. Click Values and States in the left pane.

3. In the States Measurement Unit list, click Numeric.

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

4. For each icon in the indicator set, update the values in the Start and End text boxes.

   Optionally, click the Expression (fx) button to edit an expression that sets the values of the Start and End options.

   Note

   The values in the Start and End text boxes must be numeric.

5. Select OK.

To use the percentage measurement unit

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

2. Click Values and States in the left pane.

3. In the States Measurement Unit list, click Percentage.

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

4. Optionally, change the Minimum and Maximum options to use specific values instead of automatically detecting the minimum and maximum values of the data that the indicator uses. The value of Minimum must be smaller than the value of Maximum.

   Note

   If you explicitly set minimum and maximum values, that value range is used by the indicator regardless of the actual the minimum and maximum values in the data. This means that values lower than the minimum and higher than the maximum are excluded from the evaluation that determine what indictor icon to show in the report.

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

5. For each icon in the indicator set, update the values in the Start and End text boxes.

   Optionally, click the Expression (fx) button to edit an expression that sets the values of the Start and End options.

   Note

   The values in the Start and End text boxes must be numeric.

6. Select OK.

See Also

Indicators (Report Builder and SSRS)