Introduction Have you ever worked with multiple stakeholders – who all want a dashboard about the same topic – but want different sets of data displayed? To reduce duplication of dashboards but to also ensure we can provide the best user experience we can provide an option for them to pick and choose which fields […]
2023 Week 30 | Dynamic Table Columns Read More »
Introduction We’re continuing retro month this week, and I decided to re-viz Andy’s Week 41 challenge from 2017. I chose this one because I really like the concept of being able to drill down from state into city on the same chart, but I wondered if things would be easier than the calculations required to
WOW2023 Week 30: Can you build a dynamic drill down scatterplot in one view? Read More »
Introduction If you’re as old as I am, you might remember MacGyver. For eight-year-old me, he was simply the coolest person who ever lived: he was a brilliant thinker and could get out of any situation with a Swiss Army knife and whatever was lying around. These days, to “MacGyver something” is a homage to
2023 Week 29 | Power BI: Core Visual Waffle Chart Read More »
Introduction For retro month at WOW Towers, I decided to go way back into the archive and focus on a challenge that was set by one of the original WOW coaches, Emma Whyte, in May 2017. The original challenge looked like the below image and provided a visual representation of the results of a blind
#WOW2023 | Week 29 | Re-viz : Blind leading the blind Read More »
Introduction This week’s challenge was inspired by Bas. We are creating a Timeline Visual using the Line Chart and measure-driven data labels. For this project timeline, we will be adding a today line, highlighting completed milestones, and milestones that are off-track. We will be adding descriptors to the milestones and truncating the descriptors to a
2023 Week 28 | Power BI: Project Timeline Read More »
Introduction This is week 28 of 2023 and week 2 of #RE-VIZ-IT and I’m bringing back my VERY FIRST #WOW challenge from WAY BACK in the summer of 2018! I chose this challenge because “back in my day” this use case required additional sheets, a “custom” chart and a lot of sheet swapping. If you
#WOW2023 | 28 | Can you Show & Hide Legends? Read More »
Introduction Hello and welcome to WoW week 28! This weeks topic takes it back to a fundamental lesson in CRM Analytics. I often get questions about data accuracy from users when they are comparing rows of data to the row count of a grouped chart or table. Have you ever experienced a case of “missing
2023 Week 28 | How to Handle “Missing” Rows Read More »
Introduction This week we are going to have some fun with Power Query to obtain data from a website that spans multiple pages and then visualize the data in a treemap. Treemaps are meant to display hierarchical data as a set of nested rectangles. They aren’t a great replacement for bar charts when minor differences
2023 Week 27 | Power BI: Power Query Simple Pagination and a Treemap Read More »
Introduction This July we bring you another month of challenges with a theme: We are going RETRO!Each coach will be going back through the WorkoutWednesday archives and re-vizzing a challenge from the past. It may be one of their favourite challenges, or maybe there’s a much easier way to do
#WOW2023 | Week 27 | Re-viz: Discovery Dashboard Read More »
Introduction Welcome back to Workout Wednesday! This week we’re exploring the new card visual that was released in preview this month. Key metrics are frequently displayed in reports, and in the past it took a combination of cards, images, and other visuals. Thanks to the new card visual, we now have more flexibility, options for
2023 Week 26 | Power BI: Display metrics with the new card visual Read More »
