How to Display Percentage and Label in a Column Chart in Bold Reports
Bold Reports is a powerful reporting tool that allows users to create and customize reports for various purposes. A common use case involves effectively visualizing data using Charts. For example, users may want to display both percentage values and labels in a column chart to enhance readability and interpretation. This article provides a step-by-step guide on how to achieve this using expressions within your report dataset fields.
Steps to Display Percentage and Labels in a Column Chart
- Access the Chart Report Item
- Navigate to the design view where the Column Chart item is located, which you want to format to display both the Label and Percentage values.
- Click on the settings icon, navigate to the Properties option and select the pencil icon to open the series property settings.
- Define the Expression
- Navigate to the Properties panel, locate the Data Label Settings property and select the Show Data Label checkbox to expand the data label settings.
- Locate the Label setting and click on the Expressions menu to open the Expression Editor.
- In the Expression Editor, enter the following expression to define the label format as per your requirement.
- Click the OK button to save the changes.
Use the following expression to format the value as a percentage:
="Label: " & Format(Sum(Fields!YourField.Value) / Sum(Fields!YourField.Value, "DataSet1") * 100, "0.00") & "%"
Note:
- Replace YourField with the name of your dataset field containing the values to be expressed as percentages and DataSet1 with the actual dataset name used in your report.
- / and * 100: Calculates the percentage
- Format(…, “0.00”): Formats the percentage to two decimal places.
- & “%”: Appends the percentage sign.
- Save and Preview the Report
After formatting the labels, preview the report to ensure it displays the desired format.
Conclusion
By following these steps, you can effectively display both percentage values and labels in a column chart in Bold Reports, improving the clarity and interpretability of your data visualization.
For your reference, you can download the sample report here.