Check how workbook composite bars aggregate their components and labels

Source facts

Azure Workbooks composite bars offer None, Sum and Inherit aggregation for grouped rows. None leaves the group-row column without a result. Sum adds the component columns and also sums columns referenced by the label. Inherit instead uses each component’s configured aggregation; if the label references the composite-bar column itself, that column uses Sum. Grid sorting follows the calculated sum of the rendered components. Microsoft Learn.

Applicability

Inspect the composite renderer, its component fields, the label expression and every relevant aggregation setting. This review concerns calculated group rows, not just the appearance of individual records. Keep the intended meaning of a total separate from the visual size or color of its segments.

DSE recommendation

Validate the group-row calculation and label together before using a composite bar as a status total. Ask the report owner whether components are additive counts or require another aggregation. Choose the renderer setting accordingly and document any deliberate difference between the group label and its parts. Avoid assuming that a column’s independently configured maximum remains effective when the composite renderer uses Sum. Check sorting expectations separately from label text.

Verification

Use a small, explicitly synthetic dataset with component values whose sums and maxima differ. Calculate the expected group values independently, then compare None, Sum and Inherit results with the chosen design. Inspect the group label and row ordering as well as the bar. Preserve the sample and accepted settings with the workbook so later edits can be checked without confusing a renderer change with a change in operational status.

Official references

Microsoft Learn: Composite bar renderer. Source reviewed September 9, 2026.