Power BI

2024 Week 3 | Power BI: Back to basics with a bar chart

Introduction Welcome back to Workout Wednesday! We’re taking it back to basics this week and creating a bar chart that uses small multiples and conditional formatting. We’re using the #MakeoverMonday team’s data on New Year’s Resolutions and the design is inspired by a Makeover Monday participant! A huge thank you to Ela Piwowarska for creating her submission and …

2024 Week 3 | Power BI: Back to basics with a bar chart Read More

2024 Week 2 | Power BI: Soda Pop Sales in a Jittered Column Chart

Introduction This week we have our first guest post of 2024! Today’s challenge comes from Imran Haq (LinkedIn, X). I have always admired his Deneb skills, so I’m excited to share this report with you today. We are making a jittered column chart with Deneb. The theme of soda (or pop, coke, or whatever you …

2024 Week 2 | Power BI: Soda Pop Sales in a Jittered Column Chart Read More

2024 Week 1 | Power BI: Stacked Bridge with Core Visual

Introduction This week’s challenge builds on last weeks challenge to utilise updated column fill and data labelling features from the Power BI December 2023 release. The challenge will be to create a stacked bridge chart using the core column and line combo chart. Building the bridge will require calculated tables. Intermediate users can use the …

2024 Week 1 | Power BI: Stacked Bridge with Core Visual Read More

2023 Week 52 | Power BI: Format Bar Charts with Transparency, Borders, and Detail Labels

Introduction In the December 2023 release of Power BI Desktop, some new formatting options were added for bar charts. These enhancements allow us to add borders around bars (and segments of bars for stacked bar charts), change the transparency of the fill color in a bar, and add secondary metrics to data labels.  With the …

2023 Week 52 | Power BI: Format Bar Charts with Transparency, Borders, and Detail Labels Read More

2023 Week 50 | Power BI: Clippy’s Random Gift Generator

Introduction Happy holidays to everyone who celebrates! Join us this week to get some help shopping for your friends and family, using a dataset you provide and a random number generator in Power Query. If Clippy can’t pick a gift, no one can! Have fun and create the random gift generator in whatever way you …

2023 Week 50 | Power BI: Clippy’s Random Gift Generator Read More

ring chart

2023 Week 48 | Power BI: Ring Chart

Introduction This week’s challenge uses a few layering techniques in the Deneb custom visual. Here you will be challenged to use multiple independent scales on a layered plot. Advanced users can concatenate total bars for extra credit! Requirements Power Query Obtain the dataset from Github Model and load data Power BI Desktop Obtain Deneb from …

2023 Week 48 | Power BI: Ring Chart Read More

The new button slicer used to filter a scatterplot

2023 Week 47 | Power BI: Use the New Button Slicer

Introduction The November 2023 release of Power BI Desktop includes the new button slicer visual. This visual can currently be used as a replacement for the original slicer visual when using tiles. There are more enhancements to come, but we already have a lot more control over the formatting of the slicer. We can add …

2023 Week 47 | Power BI: Use the New Button Slicer Read More

2023 Week 46 | Power BI: RFM Analysis

Introduction This week for Workout Wednesday we are performing RFM (recency, frequency and monetary value) analysis. RFM Analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency and monetary total of their recent transactions. A score of 1 to 5 is assigned for each of the three main factors. …

2023 Week 46 | Power BI: RFM Analysis Read More

2023 Week 45 | Power BI: Create a dumbbell chart with Deneb

Introduction Welcome back to Workout Wednesday! This week we’re creating a dumbbell chart to compare 2 sets of values using Deneb! If this is your first time using Deneb I highly recommend you play around with either the Vega or Vega-lite languages in the online editor, where you can load the code from examples, amend it, …

2023 Week 45 | Power BI: Create a dumbbell chart with Deneb Read More

Scroll to Top