Change Value Type Premium ✦

Default value: Percentage

This option is only available if Show change over is set to a value other than (Don’t show) and allows the difference between the main value and the value selected in the Show change over option to be displayed as:

  • Percentage: data labels will show the percentage difference between the primary value and the selected value. Looking at the example below, the percentage difference is given by the equation:

    (primary measure - target) / target

    which means:

    • primary measure (Sales Amount) = $4.13M;
    • target = $2M;

    • (4.13 - 2) / 2 = 1.065 = 106.5%.

  • Absolute value: data labels will show the difference between the primary measure and the selected option in absolute value.