en GPS Tab3 Labels (charts)


Value Format

With the Value Format you define the way values are displayed in the diagram. You can access the configuration by clicking on an element in the list.

Use Pre-Formatted Data

If this option is activated, the number formatting of the data source is used.

Value Format Pop-Up

Define the number format using the following options:

  • Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between endefr and auto.
  • Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage)ordinal (ordinal number) and time (duration).
  • Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), millionthousand and none (no abbreviation at all).
  • Thousands Separator: Replaces the thousand separator set by the selected locale.
  • Decimal Separator: Replaces the decimal separator set by the selected locale.
  • Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
  • Decimal Digits: Defines how many decimal places of the formatted number are displayed.
  • Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
  • Prefix: The input value is placed before the number.
  • Suffix: The input value is placed after the number.
  • Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
  • Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
  • Infinity Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
  • Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
  • Negative Sign: Defines how negative numbers are displayed. You can choose between minusparenthesis, and none (no sign).
  • Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
  • Time Units: If Time has been specified for the format type, the time units can be set here. The default setting interprets data values as seconds and displays them as hours and minutes with decimal places in the format h:mm.m
  • Description: Defines a description for the set configuration.

Time Units Pop Up

For the Format Type Time, a system of units can be configured with the help of the Time Units Property, which in the default setting consists of hours and minutes. Each number formatted in this way is then splitted in its values for each unit. The order of the unit list defines their relationship from the largest unit (top) to the smallest unit (bottom). Each unit contains the following options:

  • Modulus: defines the arithmetic relationship between the units. In terms of modular arithmetic, the number reflects how many entities of the next smaller unit fit into an entity of the current unit. If the current unit is the smallest of the unit system, the modulus establishes the reference to the raw value to be formatted. Thus, in the case of a unit system of hours and minutes with raw values that are given in minutes, the hours unit carries the modulus 60 and the minutes unit carries the modulus 1.
  • Prefix: Defines the local prefix with which the value of this unit should begin. It can be used as a separator to values of larger units.
  • Suffix: Defines the local suffix that should follow the value of this unit. For example, it can contain a unit abbreviation or be used as a separator to values of smaller units.
  • Omit If Zero: Sets whether values of this unit should be omitted if they equal 0.
  • Leading Zeros: Sets whether values of this unit should be displayed with one or more leading zeros (depending on the reference to the next larger unit).
  • Description: Sets a description for the unit to make it easier to recognize in the list.

Value Labels

Label Positioning

Determine the mode that controls the data labeling. Three modes are available:

  • none: The data label is not displayed.
  • fix: The data label is always displayed.
  • auto: In case of overlaps, the data label is hidden or offset; adjustable by means of Collision Adjustment

Collision Adjustment [px]

Adjusts the collision algorithm of the labels of the auto mode of the value labels. The smaller the value, the more sensitive the algorithm is to collisions. Negative values are also allowed. (Note: Bold labels are not considered by the collision algorithm, so they always appear).

Background

This option draws a colored area behind the Value Labels. With Background Color you define the desired color.

Background Color

With Background Color you define the desired color of the area.

Visible Element Labels

Define from which series the element label is visible.

Label Picking

If this option is enabled, you can use the subordinate settings to control which labels are displayed according to certain criteria. Consequently, only those labels that match the selected criteria are displayed. The following options are available:

Force First Value Label

The first label of a series is displayed.

Force Last Value Label

The last label of a series is displayed.

Force Min Value Label

The minimum value of each series is displayed.

Force Max Value Label

The maximum value of each series is displayed.

Force Before Separators

All values before a separator are displayed. This option depends on the settings under Separators.

Force Peak Labels

This option displays local minima and maxima. What a local minimum/maximum is can be controlled with the option Minimum Peak Size in %.

Minimum Peak Size in %

Determines how much values must deviate from their neighbors to be considered a local minimum/maximum.

Check Only Leading Values For Peak

The peak calculation only refers to the previous value; the following value is not taken into account.

Font

Size [px]

This property determines the font size in pixel. 

Family

Define the global font. You can choose between Arial, Tahoma, Lucida Console, Verdana and Calibri or type in the name of a font which is installed on your system.

Color

This property determines the font color as HEX code. Alternatively, the Color Picker can be used.

Title

If the Enable checkbox is activated, the title will be displayed.

Title Text

Enter a Title for the charts here. Multiline texts will be rendered accordingly, i.e. the line break will be applied. The following HTML tags can be used for formatting: 'b', 'i', 'p', 'span', 'div', 'br', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'hr', 'ol', 'ul', 'li' and 'blockquote'.

For the following result
ACME Ltd.
P&L by Segment
2021 AC, BU

this input is necessary:

ACME Ltd.
<b>P&L</b> by <i>Segment</i>
2021 AC, BU

Series Labels

Left/Top

Activate the checkboxes to display the data label on the left/top of the data series.

Right/Bottom

Activate the checkboxes to display the data label on the right/bottom of the data series.

Series Label

Enter the desired labeling of a series manually.

Custom Series Labels

If this option is enabled, you can define a custom label for each series. Otherwise, the series labels are set data-driven. Enter the desired label of a series manually here.

Max Series Labels Width [px]

Maximum width of the data series labels, up to where the padding is scaled. If this value is exceeded, the labels are cut off.

Category Labels

(De-)activate the display of the category label using Enable.

Visibility

The checkbox controls row-by-row (level x) whether the category labels should be suppressed or displayed.

Max Width [px]

If this value is greater than 0, it indicates the reserved space for the category labels in pixels. If the length of the labels is greater than the specified width, they are shortened by omission points. For values smaller or equal to zero, the reserved  space is calculated automatically. Max Category Label Width can only be set in Structure Mode and with deactivated hierarchical labels (Hierarchical Label Display set to false).

Suppress Repetition

Controls line by line (level x) whether repetitive category labels should be suppressed or displayed.

Hierarchical Label Display

Enables a hierarchical display of category labels. The category labels of each member are displayed in a separate column. The hierarchical display is only possible in Structure Mode.

Line Break Category Labels

The character or string in place of which category labels are split across multiple lines. For example, using a space for the label "ACT Jan 2001" would make it a three-line label.

Category Label Rotation [degree]

Specifies the angle by which the category labels are rotated. The rotation is counterclockwise.

Crop Category Labels

If this option is enabled, the category labels in Time mode will have a maximum width of the specified category width. If the labels are longer, they will be truncated by ... cut off.

Category Labels from Measure (only in Power BI)

This setting derives the category labels from the linked measures if no dimension is specified in the category field in the data pane.

Axis Labels

Left/Top

Activate the check boxes to display the axis label on the left/top of the data series.

Right/Bottom

Activate the check boxes to display the axis labeling on the right/bottom of the data series.

Axis Labels

Enter the desired labeling of the axis manually.

Line Break Axis Labels

The character or string where the axis labels are split over several lines (similar to the property line break category labels).


Tooltips

If this check mark is set, tooltips are displayed on the diagram at runtime, showing detailed information for the corresponding element.

The tooltips cannot be activated in Power BI via the GPS. Please use the visualization Pane in Power BI and activate the Quick Info setting to display the tooltips in the graphomate charts.

Value Format  Tooltips Pop-Up

Define the number format using the following options:

  • Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between endefr and auto.
  • Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage)ordinal (ordinal number) and time (duration).
  • Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), millionthousand and none (no abbreviation at all).
  • Thousands Separator: Replaces the thousand separator set by the selected locale.
  • Decimal Separator: Replaces the decimal separator set by the selected locale.
  • Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
  • Decimal Digits: Defines how many decimal places of the formatted number are displayed.
  • Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
  • Prefix: The input value is placed before the number.
  • Suffix: The input value is placed after the number.
  • Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
  • Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
  • Infinity Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
  • Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
  • Negative Sign: Defines how negative numbers are displayed. You can choose between minusparenthesis, and none (no sign).
  • Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
  • Description: Defines a description for the set configuration.


Scripted Formatting

Here you can define your own CSS for formatting the graphomate charts.