Introduction This week’s challenge is a little different, we will be looking to make-over a report from the Australian Bureau of Statistics. This report contains a lot of information and data sources to download, so it is up to you as to how much or how little you want to do. The primary challenge, however, …
2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia Read More »
Introduction Welcome back to Workout Wednesday! This week’s challenge is inspired by Ann Jackson, who created the challenge back in 2021 for the Tableau team. Let’s create a Customer Lifetime Value (CLV) Matrix, a tool that marketers use to segment customers based on their value and loyalty to a business. This helps marketers allocate resources …
2024 Week 6 | Power BI: Customer Lifetime Value Matrix Read More »
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. This week we are building on a faceted strip plot made in 2023 week 35, and adding a median overlay. Inspired by …
2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay Read More »
Introduction I keep seeing a particular visual shared by a Denver-area meteorologist on social media. It seems to be output from weathermodels.com. I thought it might be fun to make a modified version in Power BI, so that is our challenge this week. While we don’t have native overlapping columns, there is a native solution …
2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns Read More »
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 »
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 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 »
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 »
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 »
Introduction Radar charts have their pros and cons, but they are a great way to learn how to make a chart with an SVG image. Another reason to do this in SVG rather than with a custom visual is that it allows us to simulate small multiples by putting the measure in a table or …
