- Power BI Composite models – what’s the big deal ?1st February 2021In December 2020, Microsoft launched a preview feature in Power BI they called “ DirectQuery for Power BI datasets and Analysis Services“. Most of the Power BI community had heard of this as “composite models” and were looking forward to getting it...
- DAX “Filter Context” Explained11th January 2021Do your DAX measures return interesting values but not the numbers you want? If the answer is yes, and it happens to all of us, then the problem...
- Join our mailing list to get “The Concise Guide to DAX” pdf21st December 2020“ Why does the world need another DAX book ?” was my first question to Alison when she told me she’d written guide to the DAX language in Power BI. “...
- “Strictly Come Dancing” Telling the Story Behind the Numbers with Power BI26th November 2020Back in March this year, I did think I’d be relieved of my duty of updating the Strictly Come Dancing Power BI Report to reflect another series. To be...
- How DAX Treats Nulls & Zeros12th November 2020In DAX there is a special way to identify null or empty values and that’s by using a value called “blank”. In order to return blank values, we can use...
- The 8th Secret of the Matrix Visual: Controlling Calculations and Labels on Subtotals26th October 2020Since I wrote my blog on The 7 Secrets of the Matrix Visual in April 2019, the world has changed (in so many ways) and things have moved on with the...
- 7 Secrets of the Pie Chart21st July 2020I suppose I shouldn’t really be writing this blog because the question has to be asked, why are you using a pie chart? But if you really must, at the...