Skip to main content

Remove Insignificant Zeros From Value Display Settings

This tutorial explains how to remove insignificant zeros from value displays in your application.

Published at May 6, 2026
15 min Reading time
1. Introduction

In this example i will show you how you can remove the insignificant 0 decimals while still keeping the significant decimals displayed.

Introduction
Introduction
3. Access Display Settings

click on the column icon of the column you wish to edit.

Access Display Settings
Access Display Settings
4. Show Insignificant Zeros

Deactivate "Show Insignificant Zeros".

Show Insignificant Zeros
Show Insignificant Zeros
5. Confirm Selection

Click "Ok" to confirm your settings.

Confirm Selection
Confirm Selection
6. Change in Chart Editor

Additionally you can also change the value display in the chart editor.

Change in Chart Editor
Change in Chart Editor
7. Access Chart Editor.

Go to the chart editor

Access Chart Editor.
Access Chart Editor.
8. Select Data Labels

Click "Data labels"

Select Data Labels
Select Data Labels
9. Choose Data Field

Click on your value data field.

Choose Data Field
Choose Data Field
10. Data Field Settings

Then select the data field settings.

Data Field Settings
Data Field Settings
11. Value Settings

Click "Show insignificant zeroes" to enable or disable the display of insignificant zeros.

Value Settings
Value Settings
12. Update Data Field

Click "Update data field" to apply your changes and refresh the value display.

Update Data Field
Update Data Field

You have successfully removed insignificant zeros from value displays by adjusting the relevant settings. This improves the clarity of numerical data presentation in your application.