# Label Formatting

### Automatic Formatting

By default, the element number labels in Innofalls are formatted automatically and are oriented to the recommendations of the International Business Communication Standards (IBCS; see <https://ibcs.konveio.site/ibcs-standards-12#page=132> for details).

For each level (main and history levels) the order of magnitude of the values is determined individually and the corresponding numerical abbreviation is selected. The chosen abbreviation is used for the whole level. The abbreviations are:

* k for thousand
* m for million
* b for billion

We try to represent the numbers with a maximum of 3 digits. When smaller numbers than the order of magnitude exists, the number of decimals is increased.

### Manual Formatting

If you need more control over the number formatting, you can customize various aspects. The settings can be found on the property pane:

<figure><img src="https://3415705954-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9tIV2XT53haGp6nlAPXL%2Fuploads%2Fgit-blob-9099309ffcf05f7d15269ea92e8e8da5f01d1d3d%2Fimage.png?alt=media" alt="" width="227"><figcaption><p>Number Formatting Settings</p></figcaption></figure>

#### Scale

Controls how the numbers are scaled, with these options: *Auto*, *Trillions*, *Billions*, *Millions*, *Thousand* or *None*.\
Auto is the default setting, determining the order of magnitude automatically. *None* does not apply any scaling.\
\&#xNAN;*Note, that this can lead to a lot of decimals, if many drill down levels are present and aggregates have to be made.*

#### Hide Scale Abbreviations

When this is enabled, the numbers are scaled according to *Scale*, but the abbreviations are omitted. You may use this, if you want to show a fixed scale in the title, as proposed by the IBCS.

#### Delimiters

Lets you choose between *decimal comma* (e.g. 10.000,00) and *decimal period* (e.g. 10,000.00) and the corresponding digit group separator.

#### Decimals

The number of decimals to display. Choices are: *Auto*, *3*, *2*, *1*, *0* and *All*.

#### Decimals Percentage

The same as above, but for percentage numbers.

#### Negative Format

Whether to show negative numbers with a *minus sign* (e.g. -100) or put them in *parenthesis (e.g*. (100) )

#### Apply Thousands Separator

By default, the thousands separator isn't applied. You can change this by enabling this option.

#### Disable Formatting

Disable formatting completely. Takes the raw numbers provided by Power BI.

### Abbreviations

With the following properties you can change the suffixes when the numbers are scaled. Use this when you need the abbreviations in other languages or want to add a unit. E.g. use *mEUR* as an abbreviation for millions if you want to display *Euros in millions*.

#### Abbreviation for Thousands

By default: k

#### Abbreviation for Millions

By default: m

#### Abbreviation for Billions

By default: b

#### Abbreviation for Trillions

By default: t