Introduction I’ve had clients requesting stacked bars in various formats lately, so this challenge is timely. Stacked bars are used as a way to show part-to-whole relationship while also showing totals. The weakness of stacked bars is similar to that of the dreaded pie chart. Too many segments become confusing when trending a stacked column, …
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 …
Introduction Welcome to Week Eleven! This week, you’re going to learn about Sigma’s Subtotal, PercentOfTotal, and GrandTotal functions. I find these functions particularly useful in adding context to ToolTips or Pivot tables. In this challenge, you will explore the various types of subtotaling functions. As you work through this challenge, think about the story the different …
2024 Week 11 | Sigma: Can you find the Subtotal? Read More »
Introduction I may have gotten a little overexcited with this challenge by combining TWO problems that some of my colleagues came up against recently when trying to solve problems for their clients. That being said, this week’s challenge should be a good workout. Since the challenge applies some more advanced calculations, I have broken down …
#WOW2024 | Week 11 | Can you filter a Small Multiples chart? Read More »
Introduction Welcome back to Workout Wednesday! This week’s challenge is for folks who want to practice building reports that do have calculations but do not use complex DAX! I also had a little fun with Microsoft Designer for the images. If you haven’t had a chance to play around with this new AI design tool …
Introduction This week’s challenge is going to be longer than usual, mostly because I wanted to showcase dark mode along with a combo chart. If you’re not familiar with what a combo chart is, it can represent multiple columns using different shapes. Bars, lines, areas, and points are all fair game in a combo chart, …
2024 Week 10 | Sigma: Can you recreate this combo chart? Read More »
Introduction Hello there! I’m Yoshi and I joined the WOW Tableau coach team this year.I’ve been participating in the WOW challenges since 2020, so I am really honored to be one of the coaches. Here’s my first challenge for you: let’s practice datetime calculations and data densifications. This week, we deal with dummy data regarding …
#WOW2024 | Week 10 | Can you visualize when it gets busy? Read More »
Introduction This week have a guest author! Tausif Kazi is an expert in data visualization who is experienced in several platforms such as Sigma, Power BI, Tableau, and Snowflake. Connect with Tausif:Linkedin: https://www.linkedin.com/in/tausifkazi/Twitter: https://twitter.com/VizByTK This challenge will cover how to create a Bar chart in Pivot Tables. This will help your users quickly understand the …
2024 Week 9 | Sigma: Can you create Bar charts in this Pivot Table? Read More »
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 Welcome to this week’s Workout Wednesday. This week, we are taking advantage of some new features in the February 2024 release of Power BI Desktop. We can now have bars overlap in a clustered column chart and hide the inner borders in a stacked column chart. This week, we’ll use those formatting options to …
2024 Week 9 | Power BI: Use Bar Overlap and Border Formatting Read More »
