Introduction Hello and welcome to Week 34! Let’s get the fun started this week with Rows and Columns Total in the Pivot Table! Yes, you heard that right, we want to sum the rows and columns and yet have all the data show. Requirements Create a dev org or use an existing org you have …
Introduction This post is special! It has been sent by Pedro Gagliadri who has been working on CRM Analytics since it was called Wave! Yes, some of us have been using this tool forever! Now for the challenge: This Outliers Detection will use Z-Scores. Prepare a recipe and a dashboard that allows you to see …
Introduction We are already into the mid 2024 and hope you are ready for another challenge! This is hopefully easier than some of the previous challenges we have set in CRM Analytics this year! It contains windowing function with input widgets. Yes, you read that right! Two great tools that can make your and your …
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 Another month another week and we are already in the second quarter of the year! Let’s start this quarter strong and use timeseries in dashboards. This week is based on similar dataset as the week 4 and 9 but has been organized by energy types as a column! The challenge is to create a …
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
Introduction We are already into the 4th week of the year – WOW!! My first time creating a WoW challenge. This one is based on maps! Yes, I know CRM Analytics maps make us desire for better versions, but we can always do cool things with what already exists. But, but… this one is not …
Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …
2023 Week 01 | Power BI: Use DAX to control visual display Read More
Introduction I’m incredibly honored to be part of this amazing group of Power BI enthusiasts, and I couldn’t be more excited to share my very first Workout Wednesday challenge with you all! Have you ever looked at a visualization and thought, there has to be a better way to present this data? This week, we’re …
2025 Week 9 | Power BI: From stacked bar chart to bullet chart Read More
Introduction Welcome to week 9 – and just like that we’re already welcoming March 🚀. I’m so excited to be partnering with fellow Kansas Citian & Tableau Visionary, Felicia Styer, for this week’s challenge. Recently she created a framework for what she calls “binary parameters” which allows for a solution for multi-select parameters. The goal …
Introduction Welcome back to Workout Wednesday! This week we’re sharing an exciting announcement and inviting you to participate in the first ever Power BI Data Visualization World Championships! Workout Wednesday is collaborating with Microsoft and our very own Meagan and Kerry are judging the Grand Finale in Las Vegas! Requirements You can find the complete challenge details on …
2025 Week 8 | Power BI: Join the Power BI DataViz World Championships Competition! Read More
Can you make a bump chart? Introduction Bump charts are a great way explore changes in rank over time. They’re also a snazzy way to gamify your data and create some friendly competition. A bump chart is more interactive with a continuous time field – the chart changes when a new date part occurs. We’ll …
2025 Week 8 | Sigma : Can you Create a Bump chart? Read More
Introduction This week’s challenge is brought to you by a new guest coach, Kieran Adair. Kieran lives in Australia and has been working with Tableau for several years. He has been a long-time fan of Workout Wednesday and recently reached out to me with an idea for a challenge, which I thought you all might …
#WOW2025 | Week 8 | Can you display a ratio and a volume on the same chart? Read More
Introduction The January 2025 update of Power BI Desktop brought us some enhancements to the tree map visual, including 3 new tiling methods and options for spacing between groups and nodes. So this week we are trying out those features to make a tree map organized into columns. Requirements Download the “Regional Sales Sample.pbix” file …
2025 Week 7 | Power BI: Create a tree map organized into columns Read More
Introduction Welcome to week 6! This week, we’re looking deeper into dynamic switching. I’ve liked creating elements that dynamically change the metric or the dimension, but I ran into an issue when I also needed to have a custom sort order for one of the dynamic dimensions. I hope this helps you solve some edge …
2025 Week 07 | Sigma: Dynamic Switching and Custom Sorting Read More
Introduction I’m honored to present another challenge as a WOW coach this year.Being a coach last year was a great learning experience. It made me rethink whether my approach was truly the best and if the content was genuinely valuable for WOW participants.I’m excited to continue this journey and thankful for the chance to contribute …
WOW2025 | Week 7 | Can you Manually Color a Highlight Table? Read More
Introduction Welcome to week 6 of Workout Wednesday 2025. In this week’s challenge we will be exploring other charting options used across the web and how these can be embedded into Power BI Desktop. Using publicly accessible charts and data, we will utilise the HTML content visual to embed interactive charts within iFrames. The examples …
2025 Week 6 | Power BI: Can you embed charts from Web? Read More
Introduction Welcome to Week 6 of 2025! This week, we’re going to learn how to calculate a rolling metric, or moving sum. We’re going to use some sample Marketing Data to help us assess trends over time. We’re going to combine with some dynamic parameters to select which metric to calculate and how granular we …
