Power BI

2023 Week 26 | Power BI: Display metrics with the new card visual

Introduction Welcome back to Workout Wednesday! This week we’re exploring the new card visual that was released in preview this month. Key metrics are frequently displayed in reports, and in the past it took a combination of cards, images, and other visuals. Thanks to the new card visual, we now have more flexibility, options for …

2023 Week 26 | Power BI: Display metrics with the new card visual Read More

Bubble Chart Variants

2023 Week 25 | Power BI: Bubble Chart Variants with Charticulator

Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Meagan challenged us to create as many visuals as possible using the Deneb custom visual available in Power BI AppSource. The week before, Shannon challenged us to make as many visuals as …

2023 Week 25 | Power BI: Bubble Chart Variants with Charticulator Read More

2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb

Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Shannon challenged us to create as many visuals as possible using the core visuals available in Power BI. This week’s challenge is to create visuals using the Deneb custom visual. I have …

2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb Read More

2023 Week 23 | Power BI: Build with Core Visuals

Introduction Welcome back to Workout Wednesday! This week’s inspiration comes from the incredibly cool 1 dataset 100 visualizations project, presented by the Data Viz Project. The basic premise of the 1 dataset 100 visualizations project is that the team created 100 visualizations using a single, simple dataset. In today’s exercise, we challenge you to re-create as many of …

2023 Week 23 | Power BI: Build with Core Visuals Read More

Jittered Scatter Chart and Bubble Plot of Adelaide rainfall between 1183 and 2022

2023 Week 22 | Power BI: Inverted Jittered Scatter

Introduction This week’s challenge uses Deneb custom visual to create a jittered scatter with inverted axis plus a bubble plot with labels. Requirements Power Query Obtain the dataset from Australian Bureau of Meteorology Website Model and load data Power BI Desktop Option 1: Obtain Deneb Custom Visual from AppSource Create a Scatter Chart with point …

2023 Week 22 | Power BI: Inverted Jittered Scatter Read More

Sample Power BI report

2023 Week 21 | Power BI: Create a Theme – With a Twist!

Introduction This week, we’re building on Shannon’s theme from Week 17 2022 by creating a custom Power BI theme–with a twist!   Instead of manually selecting colors, this week you’ll use OpenAI’s free version of ChatGPT (or your Large Language Model (LLM) of choice) to create a theme. You’re in control of your prompts, and …

2023 Week 21 | Power BI: Create a Theme – With a Twist! Read More

baseball length column chart

2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games

Introduction For this Workout Wednesday, we are putting a Power BI spin on a Tableau viz created by Luke Stanke and Spencer Bauke for their Workout Wednesday 2023 Week 14.  While we could probably match nearly exactly to the original Tableau viz by using Deneb in Power BI, I wanted to see what I could …

2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games Read More

2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator

Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info.  Today …

2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More

2023 Week 18 | Power BI: SVG Clip Path

Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from …

2023 Week 18 | Power BI: SVG Clip Path Read More

2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks

Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you …

2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More

Scroll to Top