Notes from a Power BI developer
Deep dives, measured results and hard-won lessons on Power BI, DAX and performance. Written for people who have to make the report actually work.
Power BI Hex Codes in Measures for report-wide colour consistency
Store hex codes in DAX measures and every visual reads the same colour standard. Colours in hex codes, theme colour names, the secret transparent hex code, and how to find colours that go together.
Read the articleMore posts
The Ultimate Guide to the Power BI P&L Style Matrix
Financial statements break Power BI capacities at month end, and the usual fixes aim at the wrong thing. Nine builds of the same statement take an eleven second matrix down to 206 milliseconds.
Read the article
Power BI Scatter Chart Ratio Line
The scatter chart draws a ratio line and shows you no numbers at all. Here is what it actually calculates, and the DAX that puts the value and the variance back on the page.
Read the articleMore posts on the way
An ongoing series on Power BI performance, modelling and report design. New pieces land here as they are written.
Follow along on LinkedIn