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.
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
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.
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.
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.
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.