Select Page

PowerBI – Pivot and Unpivot Columns

In PowerBI there is a nifty trick where you can pivot or unpivot your data in the Query Editor. This saves you from having to do this in SQL or which ever source you are using for your data. There are just 4 simple clicks to pivot your data! This post first appeared...

PowerBI – Constant Line

The constant line feature in PowerBI seems to be one of those hidden little gems. Lets say you have an SLA with a customer of the amount of downtime allowed on the system and you want to show on a graph once they have gone above this downtime threshold, you can add a...

PowerBI – Table Heat Map

Ever wondered how to create a heat map in PowerBI without having to use a custom visual? There is now a simple way to do this by using Conditional Formatting on a Matrix table! In my example I took some Google Analytics data showing the times of the day and amount of...

PowerBI – Turn on Preview Features

Every month PowerBI releases new features. Some of the features are in preview mode and unless you turn it on you don’t get to use the preview features. This post explains how to turn them on. Firstly you need to have the latest version of PowerBI to get the latest...

Creating PowerBI Layouts

PowerBI has this great functionality where you can go and download preset layouts which make your PowerBI reports stand out more. There is a nice trick to doing this yourself. You can create layouts in PowerPoint and then save them as images. Then insert them into...

Pivot and Unpivot

One thing that I still get confused about writing is pivot queries. I find myself needing to lookup the syntax every time. Basically you use Pivot and Unpivot to change the output of a table. If you would like rows turned into columns you can use pivot and for the...