Align the Data in a Chart in a Table or Matrix (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).
Sparklines and data bars are small, simple charts that convey a lot of information with little extraneous detail. When you check this option, the values in your sparklines and data bars will align across the different cells in the table or matrix, even if there are missing values in the data they are based on.
In this image, the column chart shows daily sales for each employee. Note that for days that an employee has no sales, the chart leaves a blank and aligns subsequent days horizontally. It also aligns the charts vertically by making the sizes of the different charts relative to each other. For more information, see Sparklines and Data Bars (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.
Align the data in a sparkline or data bar
Click in the sparkline or data bar, and then click Horizontal Axis Properties or Vertical Axis Properties.
On the Axis Options tab, check the Align axes in box, and then in the dropdown box, select the group on which to align the axis.