Set a Minimum or Maximum on a Gauge (Report Builder and SSRS)
Applies To: SQL Server 2016
Unlike charts in a Reporting Services paginated report, where multiple groups are defined, gauges show only one value. Because Report Builder and Report Designer determine the context or relative significance of the one value that you are trying to show on the gauge, you must define the minimum and maximum of the scale.
For example, if your data values are rankings between 0 and 10, you will want to set the minimum to 0 and maximum to 10. The interval numbers are calculated automatically based on the values specified for the minimum and maximum. By default, the minimum and maximum are set to 0 and 100, but this is an arbitrary value that you should change. The application does not calculate your value as a percentage.
If the range of your values is large, for example from 0 to 10000, consider using a multiplier to reduce the number of zeroes on the gauge. The multiplier will only reduce the scale of the numbers on the gauge, not the value itself.
You can use expressions to set the values of the Minimum and Maximum options. For more information, see Expressions (Report Builder and SSRS).
Right-click on the scale and select Scale Properties. The Scale Properties dialog box appears.
In General, specify a value for Minimum. By default, this value is 0. Optionally, click the Expression (fx) button to edit the expression that sets the value of the option.
Specify a value for Maximum. By default, this value is 100. Optionally, click the Expression (fx) button to edit the expression that sets the value of the option.
(Optional) If the values for your minimum and maximum are large, specify a value for the Multiply scale labels by option. To specify a multiplier that reduces your scale, use a decimal number. For example, if you have a scale from 0 to 1000, you can specify a multiplier value of 0.01 to reduce the scale to read 0 to 10.