Power BI

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 »

2025 Week 16 | Power BI: Cards – NEXT Level | with emojis and variances label

Introduction ???? Happy Workout Wednesday, data fam! ???? I’m thrilled to be back with another Power BI challenge—and this one is all about taking something simple and pushing it to the NEXT level! ???? Cards are often the go-to for showing big, bold numbers. But what if we could make them smarter? More informative, expressive,

2025 Week 16 | Power BI: Cards – NEXT Level | with emojis and variances label Read More »