How to Showcase Numeric Values Excluding Grouping and Decimal Notation

When working with data in Bold BI, you may encounter a situation where you need to display only numeric values in a column, without any decimal places or group symbols. This can be essential for clarity and precision in reports where only whole numbers are relevant. Below are the steps to configure a column to show numeric values without decimals or group symbols in Bold BI.

Steps to Format Numeric Values in Bold BI

1. Configure the Grid Widget:

   • Begin by adding the fields you need to display in the grid widget.

2. Access Field Settings:

   • Click on the settings icon of the field you wish to format and click on it to open the field settings.

3. Open the Measure Formatting Dialog:

   • In the field settings, click on the ‘Format’ option. This will open the ‘Measure Formatting’ dialog box.

4. Adjust Decimal Places:

   • In the dialog box, change the number of decimal places from the default 2 to 0. This will ensure that no decimal points are displayed.

5. Set Currency and Locale:

   • If necessary, adjust the currency setting to ‘English (United Kingdom)’ or as per your requirement.

6. Remove Group Symbol:

   • To remove the group symbol (commonly a comma), clear the group symbol field so that it is empty. Please refer to the below screen shot and ensure all the fields has been set similar to the screen shot.
     
     

7. Apply Changes:

   • Click on ‘Ok’ to apply the changes. The grid will update to reflect your formatting preferences, displaying only the numeric values in the column.

From the screen shot you can understand the visualization default value and customized values:

By following these steps, you can successfully format a column in Bold BI to show only numeric values, tailored to your specific reporting needs.

Additional References

Formatting measure type column
Remember to explore the Bold BI documentation for further customization options and to get the most out of your data visualization experience.