Formatting ranges on a gauge 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, the gauge range is a zone or area on the gauge scale that indicates an important subsection of values on the gauge. Using a gauge range, you can visually indicate when the pointer value has gone into a certain span of values. Ranges are defined by a start value and an end value.

You can also use ranges to define different sections of a gauge. For example, on a gauge with values from 0 to 10, you can define a red range that has a value from 0 to 3, a yellow range that has a value from 4 to 7 and a green range that has a value from 8 to 10. If the start value that you specified is greater than the end value that you specified, the values are swapped so that the start value is the end value and the end value is the start value.

You can position the range in the same way that you position pointers on a scale. The Position and Distance from scale properties determine the position of the range. For more information, see Gauges (Report Builder and SSRS).

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

See Also

Formatting Scales on a Gauge (Report Builder and SSRS)
Formatting Pointers on a Gauge (Report Builder and SSRS)
Set a Minimum or Maximum on a Gauge (Report Builder and SSRS)
Tutorial: Adding a KPI to Your Report (Report Builder)
Gauges (Report Builder and SSRS)