Matrix chart-column types and variants, including Sparklines

Keep the same hierarchy and measures while selecting a per-column renderer: exact numbers, quantitative marks, trends, progress or financial waterfalls.

Table and Chart from the reference

Real renderers, explicit sample fields

These figures were captured from the unchanged current .pbiviz packages with documented sample data. They preserve the referenced chart families and variants. Your screenshots are included in Reference gallery. Full source data was not attached; example values are illustrative unless transcribed from a visible table. Field names and binding roles are explicit, and each example includes downloadable sample data.

Hierarchical Table with automatic variances

Chart view with overlaps and variance pins

The Table sample transcribes the visible hierarchy and AC/PY values from your reference. Automatic absolute/relative PY variance columns are part of the Matrix, not extra DAX measures. The Chart version changes the Actual renderer to Overlapped bar with a PY reference.

Choose a variant for a specific column

1. Open Specific column and choose Current view, Table or Chart.
2. Select the source or custom formula column.
3. Choose its Chart type and reference measure when needed.
4. For Sparklines, choose Series source: Columns / groups or Numeric measures, then the series scope.
5. Set width, units, typography, interpretation, scale and chart-specific options. Values settings affect column values; Row headers affect hierarchy labels.

Sparkline grain is explicit

For the line/area/column/color samples, bind Date[Month Name Short] to Columns / groups and Sales Actuals as the series measure. Show its Grand total column with the sparkline renderer and hide repeated monthly columns if desired. The series still reads the delivered Jan–Apr values. Numeric measures is an alternative when the sparkline is intentionally a sequence across measures.

The mini-chart samples include three product rows. This guide groups the options for navigation; the actual Matrix uses a contextual per-column Chart type dropdown.

Progress, gauge, pie and state inputs

These samples use a numeric Completion measure in 0–100 units and a Goal of 100. Progress and pie show the ratio to the selected reference or configured maximum. Gauges add target/range controls; State uses thresholds and labels. Keep the numeric convention explicit: a decimal 0.69 is not a stored 69 unless the formatter or maximum is configured accordingly.

P&L waterfall and integrated comparison

P&L · waterfall

P&L · integrated

Use Account[Account group], Amount and Amount PL. The running chart marks financial balances as Results; the integrated chart keeps Actual and Plan in the same row. Gross Margin % has its own percentage source formatting and pp variance. For positive-stored costs choose Financial and inherited Invert; for already-negative costs use Mathematical to avoid a second contribution inversion.

Custom formulas are chartable

A custom numeric column created in Formulas uses the same applicable Chart controls as a bound measure. Select it in Specific column and choose, for example, Bar, Bullet, Progress or a Sparkline. A percent-difference formula must opt into pp/bp/bps formatting explicitly. Percentage comparisons: pp, bp and bps without changing the source

Back to the Knowledge Base