Member-only story

Next level KPI in Power BI

Gerard Duggan
Microsoft Power BI
Published in
7 min readJul 7, 2023

Challenge Report

I took part in the Maven North Wind challenge in May 2023, which was around creating an executive KPI dashboard related to the infamous North Wind data set.

I use these challenges to get a bit creative and experiment, and this was no different. I wanted to create some dynamic KPI style visuals, and do introduce a little bit of the deneb / vega-lite visuals I had been learning about recently, with some bullet charts and overlapping bar charts.

Below is the resulting report. The deneb visuals were a little hit and miss, maybe too crowded here or too much going on, but I liked the KPIs.

They packed a lot of information into a small piece of real estate, giving plenty of “bang for your buck.”

Northwind Executive KPI Dashboard

A “How to”…

I recently created a walkthrough video on how to recreate one of the KPIs, and thought I would write an accompanying article, as some people prefer to read and reference the steps, rather than follow a video.

Here’s a link to the base data model file I use for my tutorials if you wish to follow along.

--

--

Microsoft Power BI
Microsoft Power BI

Published in Microsoft Power BI

Microsoft Power BI community sharing our Power BI experience, tutorials, use cases, tips and tricks. Learn together. Grow together. Follow our Power BI Masterclass: https://linktr.ee/powerbi.masterclass or me: https://linktr.ee/tomas.kutac

Gerard Duggan
Gerard Duggan

Written by Gerard Duggan

Business and Data Analytics Lead at KBR

Responses (4)