By Stuart Box

Charticulator Learning Power BI in Practice

Our Book – Introducing Charticulator for Power BI

    We're delighted to say that Alison's book "Introducing Charticulator for Power BI" is now available from most online bookstores.             If you want to create custom visualisations of your data in Power BI – without any coding – this is the book for you. Alison takes you through all of the Charticulator options in a clear, non-technical way. So anyone with basic knowledge of Power BI can represent their data in many striking… Read More

By Stuart Box

Microsoft Power BI in Practice

Where’s “Shared With Me” Gone ?

Are you working on Power BI and asking the same question ? Has your "Shared with me" folder in Power BI Service gone walkabout, or are you missing your "Favourites" star ? Has the side menu in Power BI service changed for you or your colleagues but not for everyone? If so, I have the explanation and can also tell you how to set things back to as they were so that everyone sees the same things again. Shared with… Read More

By Alison Box

Power BI in Practice

Visualising Targets Dynamically Using a Constant Line

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 analyses to your data". The answer was always no! That is until now. The great news is that now you can add constant lines that are no longer constant but change with user selections from slicers… Read More

1 Response

By Stuart Box

Power BI in Practice

“Strictly Come Dancing” Power BI analysis

It's traditional!, just like Christmas, Snow, Turkey and new Covid regulations December brings the final of the BBC's "Strictly Come Dancing"! We've been crunching the numbers again and have prepared the data on 19 Series, 265 Competitors and over 2,000 dances all analysed for your delight. So, is this season "the best ever" ?, are there more 10's and 40's than before ? Is Craig still the lowest scoring Judge ? All these questions and more are answered in this… Read More

By Alan Harman-Box

Power BI in Practice PowerQuery

I have the Power(query): Functions

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 at creating Functions in Power Query. Functionalisation As a reminder, we have so far translated text by calling Google's translation API via a Custom Column. However, we might find that we have many queries in our dataset that need some kind of translation; perhaps one query that is all in one language and… Read More

By Alan Harman-Box

Power BI in Practice PowerQuery

I have the Power(query): using Power Query to call REST APIs

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 Power Query, the oft-overlooked and sometimes maligned ETL engine for Power BI. Today, we're looking at APIs. [latestCourse] There are a whole host of web services available that can do all sorts of things with your data; from predicting the age, gender, or nationality of someone from their name (agify.io, nationalize.io, genderize.io), to getting… Read More

By Alison Box

DAX Power BI in Practice

Context Transition: Where the Row Context Becomes a Filter Context

"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 concept of context transition is one of the more challenging concepts to get to grips with in DAX. It can't be explained in a few short paragraphs so I apologise in advance for this rather long blog but please stick with it and read on because once you understand this concept, a whole range… Read More

By Alison Box

Charticulator Power BI in Practice

Charticulator In Power BI #14 – The Line Plot Segment

The Line Plot Segment. When most of us think of a chart or graph, we're usually thinking in terms of a "cartesian" chart where data is plotted on both the X and Y axis. We created cartesian charts when we used the 2D plot segment that we explored in my earlier posts; #5 and #6. However, with Charticulator, you always need to think "outside the box", to think laterally because there is another approach to plotting data and that is… Read More

By Alison Box

Charticulator Power BI in Practice

Charticulator In Power BI #13 – Polar Scaffolds. Pies, Peacocks & Nightingales

Polar Scaffolds. Pies, Peacocks & Nightingales. In my last post, I took you through using Horizontal and Vertical Line Scaffolds. It was there that I think we concluded we'd probably rather use sub-layouts, not Scaffolds to lay out our charts horizontally or vertically, mainly because sub-layouts give us a lot more design choices. However, there is another type of Scaffold for which hopefully you will find a plethora of uses. If you want to design circular chart types such as… Read More

By Burningsuit

Learning Training
Power BI Training London

In-Room Power BI Training Is Back

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. Throughout the pandemic, Burningsuit has continued training online, running over seventy online Power BI courses which have been very well received. However, as trainers, we have been looking forward to returning to training face-to-face. And so, we’re delighted to share that we are once again offering public Power BI course in… Read More