Year: 2024

2024 Week 34 | Power BI: Visual Calcs and Parameters

Introduction This week’s challenge is provided by guest contributor Erik Svensen https://www.linkedin.com/company/catmansolution. The workout will use visual calculations in combination with numeric parameters to highlight a period in a development chart. (Please note visual calculations do not currently publish to web) Requirements 1. Retrieve the data from Google Sheets – (you only need orders)2. Add …

2024 Week 34 | Power BI: Visual Calcs and Parameters Read More

2024 Week 34 | Sigma: Can you create a Histogram?

Introduction Welcome to Week 34! Creating a histogram in Sigma is easy when you use the built-in Bin functions to divvy up your data. This week we’ll be creating a histogram using a two different Bin functions in Sigma and some controls to make the charts more dynamic! The formatting styles and colors in this …

2024 Week 34 | Sigma: Can you create a Histogram? Read More

#WOW2024 | Week 34 | Can You Control the Displayed Data Based On Sub-Category Assignment?

Introduction Have you ever received a request to make the data displayed on a dashboard different depending on who is viewing it? For example, let’s think about a scenario where the sales for each sub-category are displayed, but the sub-categories shown vary depending on the viewer. It’s straightforward if one sub-category is to be displayed for …

#WOW2024 | Week 34 | Can You Control the Displayed Data Based On Sub-Category Assignment? Read More

2024 Week 33 | Sigma: Can you find the safe to eat items?

Introduction Sigma is all about making data manipulations and explorations accessible to everyone! This week’s challenge might sound intimidating, extracting data from JSON, but Sigma makes it a breeze. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How to Register & Get …

2024 Week 33 | Sigma: Can you find the safe to eat items? Read More

2024 Week 33 | Power BI: Segmented Donut Chart

Introduction Editor’s note: This week we have a guest post from Imran Haq (LinkedIn, X). If you haven’t already, try out his previous WoW contribution to make a jittered column chart.  The segmented bar chart from week 29, inspired some experimentation with similar designs. This week we are making segmented donut charts. These donut charts have 2 …

2024 Week 33 | Power BI: Segmented Donut Chart Read More

#WOW2024 | Week 33 | Can you build the Olympic Medals Table?

Introduction Apologies for the late challenge this week but we are sticking with the Olympic theme, this week we are building the Olympic Medal Table. I wanted to replicate as close as possible the medal table from this website. Note: The data for China is Incorrect but this is based off of the source I …

#WOW2024 | Week 33 | Can you build the Olympic Medals Table? Read More

2024 Week 32 | Sigma: Can you pick the right columns?

Introduction Welcome to Week Thirty-Two! This week, we’re going to highlight one of Sigma’s latest enhancements to Actions.  In this challenge, you’ll add actions to controls to show or hide columns in visualizations based on the column names selected in the control.  This new action gives users more control over the data they want to …

2024 Week 32 | Sigma: Can you pick the right columns? Read More

2024 Week 32 | Power BI: Track the Olympic Medal Count!

Introduction Welcome back to Workout Wednesday. This week we get to combine our love for data and the Olympics by building an Olympic medal tracker!  This is a design challenge. I have created a sample for inspiration, but feel free to build the report in any way your creative heart desires. In this challenge you’ll …

2024 Week 32 | Power BI: Track the Olympic Medal Count! Read More

Scroll to Top