Set a Minimum or Maximum on a Gauge (Report Builder and SSRS)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Unlike the chart, where multiple groups are defined, the gauge only shows one value. Since 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).
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To set the minimum and maximum on the gauge
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.