Introduction The first snowfall in Denver was unseasonably late this year. So I got curious about the data and decided to make a visualization. While this one does communicate with data, it’s taking a bit of artistic license. This is your challenge as well: create a first snowfall scatterplot with some wintery visual effects. You …
2025 Week 50 | Power BI: First Snowfall Scatterplot Read More »
Introduction In this week’s challenge we are going to try to create a chart on rising sea levels where the y-scale of mm will display on screen in physical mm. You can try this with whichever custom visual you like, but the example laid out below will be for the utilisation of the HTML Content …
2025 Week 44 | Power BI: Utilising HTML to create actual scale charts Read More »
Introduction Welcome to Week 44 of 2025! This week, we’re going to create a custom calendar visualization using a pivot table. You can find a more detailed tutorial in the Sigma Community. In addition to this tutorial, we’re going to create a form to allow users to input new events, as well as create some …
Introduction This weeks challenge is an extension of week 21, whereby we will create a timeseries smoothing over lines rather than scatter points. The challenge here is to emphasize the difference between two populations, whilst having the details visible, but not prominent – getting the opacity/strokedash (for overlapping lines) and colour contrast (for perceptibility) right …
2025 Week 36 | Power BI: Area between timeseries smoothing Read More »
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 »
Introduction This week’s visualization is inspired by the concept of rules – understanding them and knowing how to bend them (but never break them!) At a high level, Power BI visualizations are rendered using a combination of JavaScript, HTML, and CSS in a web browser. By learning the foundational aspects of various data visualization tools, …
Introduction This week’s challenge looks to create a time brush slicer. The time brush slicer can be created with Deneb or another custom visual. Requirements Obtain the data from a previous challenge Model data Option A Import Timbrush Slicer and Small Multiple Custom Visual Create a time brush slicer Create a line chart with small …
Introduction It’s the 18th week of the year and time for another CRM Analytics challenge! This week’s task is to rank the energy dataset by country for each year and create one chart out of it. This chart will show the least and most energy consumed based on the type of energy consumption selected. Sounds …
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 2024 is here! And with that, a completely new set of challenges for you, data lover. Let’s sharpen our CRMA skills with this challenge: A double bar chart displaying open and closed amounts by account. The closed amount should display won and lost amounts in a single stacked bar. The open amount should be …
