Innofalls Documentation
Back to WebsiteOpen Ticket
  • 🎉Overview
  • ▶️Getting Started
    • Installation
    • Create Your First Waterfall
    • Data Fields
      • Values From
      • Stack / Columns
      • Delta Fields
    • Videos
  • 🧭Interactivity
    • Navigation
      • Navigation Menu
      • Keyboard Shortcuts
      • Drill Down History
      • Drill Down Preview
    • Selections
    • Dynamic Deviation Charts
    • Sorting and Top N
    • Highlighting
    • Restrict User Controls
    • Animations
  • 📊Chart Types
    • Overview
    • Waterfall Charts
      • Running / Intermediate Total Waterfalls
      • Intermediate Totals and Sub Totals
      • Delta Waterfall Charts
      • Measure Delta Waterfall Chart
      • Deviation Waterfall Charts
    • Other Chart Types
      • Bar Charts
      • Stacked Bar Charts
    • Automatic Chart Selection Feature
    • Chart Orientation / Rotation
    • Adding Deviation Charts
    • Changing Deviation Charts Types
    • Special Value Treatment
  • 🎨Formatting
    • Label Formatting
    • Scenarios
    • Themes
    • Colors
    • Conditional Formatting
  • 👩‍🎓Examples
    • 📈Profit and Loss Statement
    • IBCS Styled Bar Chart with Deviations
    • Quick Examples
      • Waterfalls in Columns
      • Products Stacked by Segments
      • Comparing Quarters
      • Comparing Measures
      • Delta Waterfall by Drill Down Combination
      • IBCS Bar Chart
  • 🔑Licenses
    • Trial License
    • Paid Licenses
    • Assign Paid Licenses
    • Free License
    • Publishing to the Web
  • ❕Additional Information
    • Data Security Overview
    • Change Log
Powered by GitBook
On this page
  • Automatic Formatting
  • Manual Formatting
  • Abbreviations

Was this helpful?

  1. Formatting

Label Formatting

How to change number formatting of element labels

PreviousSpecial Value TreatmentNextScenarios

Last updated 1 year ago

Was this helpful?

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

🎨
https://ibcs.konveio.site/ibcs-standards-12#page=132
Number Formatting Settings