Introduction Welcome back to Workout Wednesday! This week we’re building a line chart using the new smoothing feature that was released this month! This week’s challenge was inspired by Andy Kreibel’s Makeover Monday challenge. We’re exploring the disappearing sea ice in the Antarctic using a line chart, looking at the extent of sea ice in millions of …
2023 Week 30 | Power BI: Build a smooth line chart Read More
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 …
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 …
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 …
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 …
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 …
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 If you spent any time working with charts, you are probably aware of the controversy around pie charts. While there are some aspects to be discussed, others are generally agreed upon. One of these ones is the fact that it’s next to iimpossible to compare the slices of two pies with each other. Nevertheless, …
