Month: November 2022

2022 Week 48 | Power BI: Conditional SVG Measures

Introduction While we looked at SVG measures in a matrix in week 20, we are taking a different approach this week. SVG measures can be used in other visuals, and they can be designed to include links.   In the below Power BI report, I’ve got 4 visuals populated by SVG measures. Initially, all 4 visuals show …

2022 Week 48 | Power BI: Conditional SVG Measures Read More

2022 Week 47 | Power BI: WoW on Twitter

Introduction Welcome back to Workout Wednesday! This week we’re going to visualize Twitter data using Twitter’s API to retrieve tweets that have been made about Workout Wednesday! You have complete creative license to visualize the data in any way that you see fit. If you have a Power BI premium license, I encourage you to …

2022 Week 47 | Power BI: WoW on Twitter Read More

#WOW2022 | Week 47 | Can you label and sort small multiples?

Introduction Small multiples can be a good way to see overall trends across several categories, but sometimes it can be tricky to get the sorting and labels right, so that’s what we’ll practice this week! Since baseball season is over now, we’ll look at overall win percentage from 1998 to 2022 for Major League Baseball …

#WOW2022 | Week 47 | Can you label and sort small multiples? Read More

2022 Week 46 | Power BI: My Second Deneb

Introduction During week 42’s community month challenge brought to us by Thys van der Westhuizen – Thys built on my week 37 challenge – My First Deneb. For that week’s challenge I built out three basic bar charts using Deneb visuals, and subsequently, Thys continued to build a few more amazing visuals in his challenge. …

2022 Week 46 | Power BI: My Second Deneb Read More

#WOW2022 | Week 45 | Average Patient Waittimes

Introduction This week’s challenge was derived from a project that I helped some colleagues with. My colleagues were working on a client project for a travel company. They wanted to be able to compare a selected “Event Date” with an average travel day. The aim was to see if and how travel patterns might be …

#WOW2022 | Week 45 | Average Patient Waittimes Read More

How Brits met their partners

2022 Week 45 | Power BI: Ribbon Chart (Advanced)

Introduction Another Deneb visual this week – creating a custom Ribbon Chart.   This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a …

2022 Week 45 | Power BI: Ribbon Chart (Advanced) Read More

2022 Week 44 | Power BI: Customer Lifetime Value

Introduction This week, our challenge is to calculate customer lifetime value by quarter using DAX.  This is an advanced challenge so buckle up! As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.  The Tableau challenge was… you guessed it… developing a chart …

2022 Week 44 | Power BI: Customer Lifetime Value Read More

2022 – WEEK 44: What is the lifetime value of customers?

Introduction This is probably my favorite challenge of the year. So i’m saving it for near the end. You’ll need level-of-detail and table calculations to solve this one. For this challenge you need to calculate customer lifeftime value (in sales). While their are many ways to do this. We are going to keep this as …

2022 – WEEK 44: What is the lifetime value of customers? Read More

Scroll to Top