Writing
Articles on Power BI, DAX and AI, newest first. burningsuit's older posts are in the archive below.
We're all middle management now
Agentic development in Power BI: what an agent is, how far to trust its work, and what handing work to it costs.
From the archive
Where do I make data transformations in Power BI? Roche's Maxim
Roche's Maxim: transform data as far upstream as possible, as far downstream as necessary. Stuart Box's 2021 post, which Matthew Roche credited as the first.
The 8th secret of the matrix visual: controlling calculations and labels on subtotals
Use ISINSCOPE to give Power BI matrix subtotals their own calculation, such as % of parent row total, and give each subtotal level its own label.
Categorising measures into numeric ranges or "bins"
Count how many customers' total sales fall into each numeric range, or bin, with an unrelated table of ranges and one DAX measure in Power BI.
Best and worst: two approaches to finding top or bottom N percent using DAX
Find your top or bottom 10 percent of customers by sales in DAX: rank them with RANKX, then use a fixed percentage or slicers that choose it.
7 secrets of the matrix visual
Seven matrix visual secrets in Power BI: grand totals, expanding a level, layout, per-level subtotals, values on rows, text values, conditional formatting.