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
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 …
Introduction November is a special month. Workout Wednesday is viewed by thousands of people each week across the globe. And this month we are highlighting those across the world who have great ideas and concepts to share with others. First up is Venkatesh Iyer. Its his second time hosting this year, but if you’ve read any of …
2023 Week 44: Can you build an UpSet Plot with just One Calculated Field? Read More
Introduction I joined the Workout Wednesday crew in 2018. Since then I’ve provided–from what I can count–64 challenges. And I’ve never been short of real-life challenges. In my job, I’ve encountered so many problems that I could take apart and provide to the community without exposing who my customers were at the time. Many of …
Introduction This week’s challenge was inspired by FiveThirtyEight’s Nobody had more style than Jay Wright created by Ryan Best For this week’s challenge we will be creating SVGs with shape elements that are coloured dynamically based on field values. Create your own SVG and add your own flair to this design. Requirements Obtain the source data …
Introduction Have you ever worked with multiple stakeholders – who all want a dashboard about the same topic – but want different sets of data displayed? To reduce duplication of dashboards but to also ensure we can provide the best user experience we can provide an option for them to pick and choose which fields …
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 …
Introduction This week we are getting a bit artistic and taking inspiration from a visual that was recently published by Robin Rohwer on Twitter. She created a connected scatterplot that uses a flower emoji to represent each point. I thought her visual was wonderful, so I set out to create something like it in Power …
2023 Week 13 | Power BI: Create a connected scatterplot with image markers Read More
Introduction This week we are making a table with microcharts (sparklines). Power BI does offer built-in sparklines, but sometimes we want formatting options not available with the defaults. Our challenge this week uses both the built-in sparklines and custom SVG images in a table. Requirements Create a custom column with the following logic: If the …
2023 Week 09 | Power BI: Create a table with custom and built-in microcharts Read More
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 …
