Skip to content
ALLURE
Skip to main content

Allure Analytics

Automatic comparisons and variance columns

Add PY, PL, Budget or FC once and keep absolute/relative comparisons when groups are added.

Automatic and configured comparisons

Chart and Table automatically include absolute and relative variances for bound comparison scenarios. Adding Month to Columns / groups repeats them in every group rather than removing them. New bound scenarios are added while explicit hidden columns or disabled comparisons remain respected.

  1. Bind Actual and the comparison measures.
  2. Open Compare to choose base, reference, direction and absolute/relative/both/none output.
  3. For Chart, choose variance bar, pin or another applicable chart in Specific column.
  4. Format units, interpretation, zero line and limits; check representative positive and negative rows.

Make variance bars readable

Variance charts controls full-row-height bars, vertical padding, zero-line color/width, centered zero and labels beside bar ends or at the column edge. Absolute and percentage variances have independent scales. Automatic scaling uses the loaded visible rows.

Actual/Prior values with separate absolute bars and relative pins.

Click to enlarge.

Cap a large outlier

Set Absolute variance limit in raw measure units or Relative variance limit (%). Zero means Automatic. Clipped marks can show an overflow arrow, while their label and tooltip keep the original amount. Level is the default variance scaling scope.

Missing reference

Blank operands or a zero denominator give blank relative variance. The visual does not manufacture prior-year values.

Percentage rows are independently scoped

Rows such as Gross Margin % can show pp or bp/bps for their automatic variance without changing amount rows or their source percentages. Custom column formulas also support an explicit percentage-variance result flag. Percentage comparisons: pp, bp and bps

Back to the Knowledge Base

Show the comparisons you need

Native comparison editor: absolute and relative versus relative-only display.

3840 × 2160 tutorial canvas at 20 fps. Real 2560 × 1392 Power BI Desktop screenshots retain their native size; this is a paced step sequence.

  1. Start with the measures — The report already binds Sales Actuals and Sales LY. The visual calculates their differences.
  2. Open Compare — Check Comparison measure (A) and Reference measure (B). This example compares Sales Actuals with Sales LY.
  3. Choose the display — Set Show to Relative only. Leave Reverse off to retain the A minus B direction.
  4. Apply the change — The absolute variance column closes. The relative variance remains, including the total of (14.0%).

Download the 4K animated GIF · Download the 4K MP4