Label Formatting

How to change number formatting of element labels

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:

Number Formatting Settings

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. 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