Kerry Kolosko

Star Trek timeline data plotted on a sine wave

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals

Power BI, Workout Wednesday / By

Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More

Overlapping Histogram

2024 Week 13 | Power BI: Overlapping Histogram

Power BI, Workout Wednesday / By

Introduction In this week’s challenge we are creating an Overlay Histogram. An overlay histogram utilises overlapping columns or bars to compare two populations. In this case, we are utilising the speed dating data from a previous challenge to compare male and female differences in dating preferences. Requirements Obtain the data from the Workout Wednesday 2022 …

2024 Week 13 | Power BI: Overlapping Histogram Read More

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals

Power BI, Workout Wednesday / By

Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations …

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More

DataViz Makeover of bar chart

2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia

Power BI, Workout Wednesday / By

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

Faceted Strip Plot with Median Overlay

2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay

Power BI, Workout Wednesday / By

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

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

Power BI, Workout Wednesday / By

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

ring chart

2023 Week 48 | Power BI: Ring Chart

Power BI, Workout Wednesday / By

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

SVG Pictrogram

2023 Week 32 | Power BI: SVG Pictogram

Power BI, Workout Wednesday / By

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 …

2023 Week 32 | Power BI: SVG Pictogram Read More

Project timeline Visual

2023 Week 28 | Power BI: Project Timeline

1 Comment / Power BI, Workout Wednesday / By

Introduction This week’s challenge was inspired by Bas. We are creating a Timeline Visual using the Line Chart and measure-driven data labels. For this project timeline, we will be adding a today line, highlighting completed milestones, and milestones that are off-track. We will be adding descriptors to the milestones and truncating the descriptors to a …

2023 Week 28 | Power BI: Project Timeline Read More

Scroll to Top