- 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. “ Well, I’ve written the guide that I wish had been around when I was first learning DAX, aimed at...
- “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...
- Sentiment Analysis in Power BI, analyse text reviews and a Premium tip.14th July 2020Power BI is great at analysing numeric data. Numbers like values, costs, stock holdings and averages can all be worked up into informative charts and...
- 7 Secrets of the Line Chart10th July 2020The line chart is the go-to chart type to visualise data over time. Typically, this visual is used to analyse your data by year, quarter, month or by...