Report kits

The patterns behind my reports, packaged so your team can adapt them.

Each kit is a working pattern on invented demo data: the model pieces, the DAX, the test data and a guide. Nothing from client work. They are in preview: join the list and you hear first when each one opens.

RLS Pattern Kit

One report for the whole team. Each person sees only their rows and lands on their own page.

Preview
Home checks the email, finds the person in the roster and opens their page: My team for Leo (manager), My accounts for Sam (rep). Same file; RLS keeps the rows to their own.
The hierarchy role keeps every roster row whose path contains the signed-in email.

For

Teams copying reports per region or per manager, or editing role expressions every time someone moves.

Inside

  • Hierarchy role in one line: PATHCONTAINS on the roster path
  • Access-table role: access changes become data changes
  • Persona measures: welcome line, landing page per person, a viewing-as check
  • Test-as-anyone Power Query function
  • Demo data and a generated test matrix: who should see what, before you publish
Row-level security, explained

Source: demo data (Meridian Goods), rendered from the kit's own patterns

DAX KPI Card Library

KPI cards that answer how much, good or bad, which way and compared to what, from one library of DAX functions.

Preview
Trend, lower-is-better, goal and mini cards. Switch the quarter and every card rolls, including the verdicts.
The header is one function call per page; the cards are one call per measure.

For

Developers maintaining long HTML measures, or reports where a fall in cost still shows red.

Inside

  • 17 DAX user-defined functions: format, period, trend, card pieces, one palette
  • Trend, lower-is-better, goal-attainment and mini-tile cards
  • A header navigation bar from one function call per page

Source: demo data (Meridian Goods), rendered from the kit's own patterns

Report Design Kit

The look of a finished report as files: a theme, three page backgrounds and the table rules.

Preview
Every page in the same order: background, header, welcome, cards, visuals.
Three backgrounds, each for a kind of page. Nothing in front of them moves.
League table and heatmap: right-aligned figures, one highlight, one colour scale.

For

Teams whose reports work but look busy, and anyone starting a new report family.

Inside

  • Report theme JSON: one highlight colour, white visuals on a pale canvas, one shadow
  • Three 1920 × 1080 backgrounds: flat canvas, header band, welcome hero
  • League table and heatmap rules, with the conditional formatting to match

Source: demo data (Meridian Goods), rendered from the kit's own patterns

Hear when a kit opens

One email when each kit is ready, plus the occasional fix worth stealing.

Get the next Engineering Note

Practical DAX, semantic model and Fabric notes. 1–2 a month, unsubscribe any time.

1–2 useful notes a month. Unsubscribe at any time.

Want it set up in your tenant instead?

I can fit any of these patterns to your model and your team, then hand it over with tests.