Export (0) Print
Expand All
Expand Minimize

How to: Set a Minimum or Maximum on a Gauge (Report Builder 2.0)

Unlike the chart, where multiple groups are defined, the gauge only shows one value. Since Reporting Services cannot 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.

To set the minimum and maximum on the gauge

  1. Right-click on the scale and select Scale Properties. The Scale Properties dialog box appears.

  2. In General, specify a value for Minimum. By default, this value is 0.

  3. Specify a value for Maximum. By default, this value is 100.

  4. (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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft