Tiers · Tables

The matrix header you draw on a whiteboard

Many reports need a table where the columns are grouped, with a subtotal for each group and a total at the end. Power BI’s matrix can nest column fields, but it can’t put a plain label over the whole header, it repeats the measure name under every column, its subtotals look like any other column, and you can’t fold a group away to its subtotal.

Try Pro free for 14 daysDownload

Free to use, with no watermark and no time limit. Pro from $3 per viewer a year.

Online orders lead in every cityOrders by city and channel
Orders⌄ Online⌄ In storeCityWebAppSubTillKioskSubOslo41228669898175273Bergen20513133677190267Trondheim15810226051140191Stavanger1318821944121165
Light report
Online orders lead in every cityOrders by city and channel
Orders⌄ Online⌄ In storeCityWebAppSubTillKioskSubOslo41228669898175273Bergen20513133677190267Trondheim15810226051140191Stavanger1318821944121165
Dark report

What it shows

Tiers draws the table the way you would sketch it: a label over the columns, the top level as boxed group headings, the next level under them, a shaded subtotal column at the end of each group, and a total column and row. Click the arrow next to a group to fold it to its subtotal; the report remembers which groups are folded. Every subtotal and total is your measure, worked out by Power BI for that group, so a distinct count or a ratio is right in the subtotals too.

How to set it up

Add Tiers from AppSource or the .pbiviz file, then drag in:

Rows
One field, such as city.
Column groups
The header levels, top first. Two levels are free; a third and fourth are Pro.
Value
The measure in every cell, such as orders.

Read the full Tiers guide

In the report

  • Hover a cell for its row, its column groups and the value.
  • Click a row name or a cell to filter the rest of the report; Ctrl+click to pick several.
  • The header stays at the top and the row names at the left when the table scrolls.
  • The measure’s number format, with display units if you want them.
  • Light or dark background, high-contrast mode, and your own subtotal and total shading.
  • Tab into the table and move with the arrow keys. The fold arrows are buttons. Screen readers get a real table with headers.
  • The format pane and messages are in English and Norwegian.

Free and Pro

FeatureFreePro
Label over a two-level column header✓✓
Shaded group subtotals, total column and total row✓✓
Fold groups to their subtotal, saved in the report✓✓
Own labels, shading colours, display units, row spacing✓✓
Tooltips, filtering, keyboard, high contrast, light and dark✓✓
More levels: a third and fourth column level, each with its own subtotals—✓
Percentages: each cell as a share of its row total or column total—✓
Shading by value: cells darken with their value, like a heatmap—✓

Free features always work, with no key and no tag. Pro features need a licence key for Tiers or Everything. Without a valid key, Tiers shows two levels, plain values and no shading, with a short notice and a “Try Pro free” button. A paid key keeps Pro working for 7 days after it runs out, so a late renewal never breaks a report.

Your data stays in your report

Tiers makes no network calls and stores nothing outside the report. The licence key is checked inside the visual, so it also works offline, in Report Server and in locked-down tenants.

How the visuals handle data

Pro licence
$36per creator a year
$3per viewer a year

For Tiers alone. The entire suite is $90 per creator and $7.50 per viewer, or license the whole organisation.

See pricing

More Grafpoint visuals