# Formatting and Localization of Widget Data

> You can change the way numbers are displayed and formatted in widgets. For example, you can display a number as a percentage, and you can define the number of decimal places.

*Source: https://docs.sisense.com/main/SisenseLinux/formatting-numbers-in-widgets.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

You can change the way numbers are displayed and formatted in widgets. For example, you can display a number as a
percentage, and you can define the number of decimal places.

## Formatting Numbers in Widgets

### How to Format Numbers in a Widget

1. In the Widget Designer, for example, in the X-Axis, Y-Axis, Values, Categories areas, and so on, hover over
   and click **123**.
2. Select how the number, currency or percentage appears. The preview area at the bottom of this window shows a
   preview of how each option will appear in the widget.

By default, each abbreviation rule is applied to the number that matches its level. For example, when 1M is selected, it will only abbreviate those values that are equal to or bigger than 1M.

![Widgets format number example](https://docs.sisense.com/main/Resources/Images/widgets-format-number-example_1000x776.png)

### Abbreviate All Values

When you need all of the data values to be formatted as per the selected abbreviation - apply the additional option “Abbreviate all values“.

For example, when only 1M is selected:

- 40 000 > 0.04M
- 445 514.3 > 0.45M
- 952 823.07 > 0.95M
- 1 200 000 > 1.2M

If several abbreviations are selected - the values are rounded to the next highest selected abbreviation for formatting. For example, if “1K” and “1B” are selected:

- 400 > 0.4K
- 445 514.3 > 445.51K
- 952 823.07 > 952.82K
- 1 200 000 > 1200K
- 1300000999 > 1.3B

This should be useful for financial and other fields, where consistent formatting is required across the whole data.

![Widget format number dialog](https://docs.sisense.com/main/Resources/Images/widget-format-number-dialog_1000x661.png)

## Currency Settings

The default currency symbol used in the dashboard is the US dollar ($), however you can change the symbol by
either selecting another symbol from the drop-down list, or by typing in a different symbol. The list of
currency symbols will include common currency symbols, the currency defined in your browser's locale settings,
and the symbol that you added (if you did so).

![8 6currency1 300x293thumb](https://docs.sisense.com/main/Resources/Images/8-6currency1-300x293thumb0300.png)

After you select a different symbol, additional viewers will see the same symbol that you applied.

## Locale Settings

The formats for dates, times and numbers in your dashboards are based on your computer's operating system or
browser's locale settings (depending on which browser you use):

- For Chrome, Firefox and Edge, the user's browser settings are used:

  - Chrome - See [Change Chrome languages & translate webpages - Computer - Google Chrome Help](https://support.google.com/chrome/answer/173424?hl=en&co=GENIE.Platform%3DDesktop)
  - Firefox - See [Use Firefox in another language | Firefox Help](https://support.mozilla.org/en-US/kb/use-firefox-another-language)
  - Edge - See [Use Microsoft Edge in another language - Microsoft Support](https://support.microsoft.com/en-us/microsoft-edge/use-microsoft-edge-in-another-language-4da8b5e0-11ce-7ea4-81d7-4e332eec551f)
- For Safari, the computer system settings are used:

  - Safari - See [Change the language your Mac uses](https://support.apple.com/en-il/guide/mac-help/mh26684/mac)

The following locales are supported:

- de-DE - German
- en-US - English
- es-AR - Spanish (Argentina)
- es-ES - Spanish (Spain)
- fr-FR - French
- it-IT - Italian
- ja-JP - Japanese
- ko-KR - Korean
- nl-NL - Dutch
- pt-BR - Portuguese (Brazil)
- ru-RU - Russian
- tr-TR - Turkish
- zh-CN - Chinese

### Managing Localization Settings

#### Fetching Current Settings

Use [GET /settings/globalization](https://developer.sisense.com/guides/restApi/v1/?platform=linux&spec=L2023.6#/settings/getGlobalization) to get the current system localization settings on the instance.

Example results:

[Copy](javascript:void(0);)

```
{  
  "localization": {  
    "default": "en-US",  
    "autoDetectEnabled": true  
  },  
  "language": "en-US"  
}
```

The `localization` attributes:

- `"default"` - Identifies the default locale of the system
- `"autoDetectEnabled"` - Boolean that indicates whether locale settings should be inherited from Sisense (the default) or inherited from the browser/system settings of the user’s computer:

  - `true` - The locale is taken from the user’s computer
  - `false` - The locale is taken from the Sisense settings (default)

#### Changing Locale Settings

The following endpoints are used to add or adjust locale settings:

- [POST /settings/globalization](https://developer.sisense.com/guides/restApi/v1/?platform=linux&spec=L2023.6#/settings/add)
- [PUT /settings/globalization](https://developer.sisense.com/guides/restApi/v1/?platform=linux&spec=L2023.6#/settings/update)

After the settings are changed, the new locale settings will be applied to the user when they re-login into the application.