Custom Labels for X-Axis

By default, the axis labels in the Chart data region are displayed in one line. To make the X-axis labels of the chart appear in multiple rows, follow these steps:

1. From the Report Explorer, expand the Chart data region node and select Plot Area > X Axis - [Plot1].

2. From the Inspector tab, go to Labels > Labels Row Count property.

3. Set the Labels Row Count property to '3'.

4. Preview the report.

Add Data Labels to Plots

To improve chart readability, you can add custom data labels to the plots. The Template property available for the chart plot labels lets you choose the data from the data source, or a custom template that you create using the Text Encodings.

For example, let us refer to the built-in report 'Income Statement' where a Column Chart displays Profit/Loss in a given period. To display the additional information on total revenue on each data point, we will create a custom data label (a custom template) and set it as a label to appear over the data points as follows:

1. From the Report Explorer, expand the Chart data region node and select Plot Area > Plot - [Plot1].

2. In the Inspector tab, go to Encodings Common > Text Encoding property.

3. Click Add and then Edit to configure the text encoding properties as described below:

   1. Values: {Revenue}

   2. Template Key: TotalRevenue

   3. Target: Label

   4. Aggregate: Sum

4. With the plot selected, go to Label Text > Template and select 'TotalRevenue' from the drop-down (the Template Key we created in the previous step).

5. Under Label Text, do the following customizations:

   1. Go to the Template property, select the Data Binding option, and then select Expression.

   2. In the Label Text - Template dialog that opens, enter the expression: Tot. Revenue: {TotalRevenue}and click Save.

   3. Go to the Position property and set it to 'Outside'.

      You can do further customize the appearance of the data label text.

6. Preview the report.