Power BI

Screenshot of a lollipop chart created using Power BI

2025 Week 22 | Power BI: Create a lollipop chart

Introduction Happy Wednesday Power BI Folks! This is my first time creating a Power BI Workout Wednesday exercise, and I’m excited (and a little nervous) to share it with you all! Thank you for being part of my learning and teaching journey. Let’s grow together! Have you ever wanted to create a Lollipop Chart in Power BI …

2025 Week 22 | Power BI: Create a lollipop chart Read More »

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing

Introduction When looking at timeseries data, we may encounter high variability from one week to the next, creating highly jagged and difficult to read charts. There are a number of techniques to smooth the lines to better depict trend. Some may use rolling averages, others, like YouGov, use LOESS regression. https://yougov.co.uk/topics/society/trackers/how-often-brits-exercise In this weeks challenge …

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing Read More »

2025 Week 20 | Year-over-Year Selected Metric Trends

Introduction Welcome to Week 21 of 2025! This report allows users to select a performance metric (e.g., Revenue) and compare its values across 2024 and 2023. It provides a flexible way to explore year-over-year changes and spot trends or anomalies through interactive visuals. Good luck! -Andrei Requirements Main Visual: Area Chart with Year-on-Year Comparison Green …

2025 Week 20 | Year-over-Year Selected Metric Trends Read More »

Screenshot of a Power BI report that looks like a line chart with a picture of James in the lower right corner.

2025 Week 17 | Power BI: Create a control chart

Introduction Welcome back to Workout Wednesday!  This week we’re building a Control Chart. Control charts can be used to track a specific process measure – such as sales, defects, or processing time – over a period of time. A few common uses are: Manufacturing: Monitoring defect rates and equipment performance  Healthcare: Tracking infection rates, patient …

2025 Week 17 | Power BI: Create a control chart Read More »