Comment on page
How to change number formatting of element labels
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.
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
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.
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.
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.
The number of decimals to display. Choices are: Auto, 3, 2, 1, 0 and All.
The same as above, but for percentage numbers.
Whether to show negative numbers with a minus sign (e.g. -100) or put them in parenthesis (e.g. (100) )
By default, the thousands separator isn't applied. You can change this by enabling this option.
Disable formatting completely. Takes the raw numbers provided by Power BI.
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.
By default: k
By default: m
By default: b
By default: t