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:
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
Last updated