• Join our mailing list to get “The Concise Guide to DAX” pdf
    21st 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 BI
    26th November 2020
    Back 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 & Zeros
    12th November 2020
    In 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 Subtotals
    26th October 2020
    Since 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 Chart
    21st July 2020
    I 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 2020
    Power 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 Chart
    10th July 2020
    The 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...