• 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 referring to is the option that you can find on the magnifying glass, now labelled “Add further...
  • “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...
  • Charticulator in Power BI #7
    28th June 2021
    Using Two Categorical Axes. In my very first post on Charticulator, I urged you to forget everything you currently know about creating conventional...