• Using a Continuous X-Axis on Column Charts for Year and Month Labels
    28th April 2022
    Ever wanted to do this on the x-axis of a Column chart… …that is use a continuous x-axis for Month and Year labels? A continuous x-axis is used for date type data where Year and Month labels are incrementally spaced according to the number of data...
  • Visualising Targets Dynamically Using a Constant Line
    28th February 2022
    One of the questions that I’ve been asked consistently over the past five years is “can we have a dynamic constant line?”. The Constant Line they are...
  • “Strictly Come Dancing” Power BI analysis
    13th December 2021
    Yes, “Strictly Come Dancing” is with us yet again for the 21st Series! And yes, we’re crunching the numbers again not only on this series' contestants...
  • I have the Power(query): Functions
    29th September 2021
    In the last episode of I Have the Power, we looked at calling REST APIs via Custom Columns using M’s Web.Contents function. Today, we’re going to look...
  • I have the Power(query): using Power Query to call REST APIs
    27th September 2021
    Welcome to “I Have the Power(query)” – a new intermittent series here on the Burningsuit blog, delving into some of the more advanced use cases of...
  • Context Transition: Where the Row Context Becomes a Filter Context
    24th August 2021
    “Nothing in life that’s worth anything is easy.” Barack Obama. And we could also say that nothing in DAX that’s worth anything is easy! Certainly the...
  • In-Room Power BI Training Is Back
    5th August 2021
    After a turbulent time for us all, we can now see the light at the end of the tunnel – and can greet the return of in-room, face-to-face training...