How to Format Chart Labels to Display Values in Thousands as 'K' in Bold Reports
Bold Reports enables you to enhance data visualization by formatting chart labels to display large numeric values in a simplified, readable format. This guide demonstrates how to configure the y-axis of a chart to show values in thousands using the “K” suffix, making your reports become more concise and user-friendly—especially when presenting high-volume data.
Steps to Format Y-Axis Labels with “K” Suffix
-
Open the Chart in the Report Designer
-
Launch the Report Designer. Select the chart you want to modify.
-
In the Data Panel, choose the field you want to display with the “K” suffix.
-
-
Set the Expression for the Data Field:
- In the data field properties, set the following expression to convert values to thousands:
- In the data field properties, set the following expression to convert values to thousands:
=(Fields!SiteID.Value / 1000). -> This divides the y-axis values by 1000 to convert them into thousands.
-
Configure the Label Format:
- Navigate to the chart’s properties.
- Go to
ValueAxis
->Label Format
. - Set the label format expression to:
="K"
-
Save and Preview the Report
-
Save your changes. Preview the report to verify that the Y-axis values are displayed in thousands with the “K” suffix.
-