Intermediate

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure

Introduction While you can’t directly populate a slicer with a measure, you can use a slicer to filter other visuals based upon measure amounts. That is what we are doing in this week’s challenge. In the report below, we have a budget analysis report. The report allows users to filter the projects table to projects …

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure Read More

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image

Introduction Continuing on last week’s infographic theme, we are recreating an infographic from Visual Capitalist this week, this time showing average lifespan for different mammals.  We will be using a scatterplot visual of your choice this week. I made two demo versions, one using the Deneb custom visual and one using the Enhanced Scatterplot custom …

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image Read More

Star Trek timeline data plotted on a sine wave

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

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

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz

Introduction Welcome back to Workout Wednesday! This week we’re recreating a really neat viz that was originally created by Flávio Matos for the Tableau team back in 2023. Flavio created the Periodic Table of Wine, with an option for users to select the food they’ll be eating to help them pair the perfect wine. Today, …

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz Read More

2024 Week 12 | Power BI: Contact Cards and Headerless Tables

Introduction This week’s challenge uses a custom visual to achieve some formatting that cannot currently (as of March 2024) be achieved using core visuals. First, we have a table that contains 2 columns and no headers. Next, we have some contact cards that contain both an image and text. The catch is that the number …

2024 Week 12 | Power BI: Contact Cards and Headerless Tables Read More

2024 Week 11 | Power BI: IBCS Charts with Injae

Introduction Welcome back to Workout Wednesday! This week we’re taking notes out of Injae Park’s portfolio and recreating one of his IBCS charts. IBCS, or the International Business Communication Standards is a set of rules to level up how businesses talk and share info. Think of it as a cheat code for clearer charts and …

2024 Week 11 | Power BI: IBCS Charts with Injae Read More

2024 Week 09 – Formulate Select and Navigate Dashboard

Introduction Almost the end of February! Time flies fast! – And another WoW Challenge is here!!  This week is based on the same dataset and maps we had as a challenge during Week 4! The changes are adding one KPI, and one top 5 chart to the existing dashboard. Then add an Interaction (not binding) …

2024 Week 09 – Formulate Select and Navigate Dashboard Read More

2024 Week 6 | Power BI: Customer Lifetime Value Matrix

Introduction Welcome back to Workout Wednesday! This week’s challenge is inspired by Ann Jackson, who created the challenge back in 2021 for the Tableau team. Let’s create a Customer Lifetime Value (CLV) Matrix, a tool that marketers use to segment customers based on their value and loyalty to a business. This helps marketers allocate resources …

2024 Week 6 | Power BI: Customer Lifetime Value Matrix Read More

Scroll to Top