Range charts in a paginated report (Report Builder)
Article
Applies to:
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
A range chart type in a paginated report displays a set of data points that are each defined by multiple values for the same category. Values are represented by the height of the marker as measured by the value axis. Category labels are displayed on the category axis. The plain range chart fills in the area between the top and bottom value for each data point.
The following illustration shows a plain range chart with three series.
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.
Variations
Smooth range. A smooth range chart displays curved lines rather than straight.
Column range. A column range chart uses columns instead of areas to display the ranges.
Bar range. A bar range chart uses bars instead of areas to display the ranges.
Data Considerations for Range Charts
Range chart types require two values per data point. These values correspond with a high value and a low value that defines the range for each data point.
Range charts are useful for analysis only if the top values are always higher than the bottom values. If this is not the case, consider using a line chart. If the high value is lower the low value, the range chart will display the absolute value of the difference between these values.
If only one value is specified, the range chart will display as if it were a regular area chart, with one value per data point.
Range charts are often used to graph data that contains minimum and maximum values for each category group in the dataset.
Displaying markers on each data point is not supported on the range chart.
Like the area chart, in a plain range chart, if the values in multiple series are similar, the series will overlap. In this scenario, you may want to use a column range or bar range chart instead of a plain range chart.
Gantt charts can be created using a range bar chart.
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.