- Using a Continuous X-Axis on Column Charts for Year and Month Labels28th April 2022Ever 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 Line28th February 2022One 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 analysis13th December 2021Yes, “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): Functions29th September 2021In 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 APIs27th September 2021Welcome 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 Context24th 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 Back5th August 2021After 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...