Introduction This week’s challenge is inspired by one of the new features announced at Devs on Stage at the recent Tableau Conference.Devs on Stage unveiled nearly 30 new features. Chart Layers stole the show for me, but I’m also genuinely excited about Data Driven Formatting—the ability to dynamically change font size, container size, color, and […]
#WOW2026 | Week 20 | Expanding Rows Read More »
Tableau, Workout Wednesday
Introduction This challenge focuses on a powerful Power BI technique: conditional visibility using overlapping visuals and dynamic transparency. Instead of hiding visuals entirely, you’ll learn to control visibility through background color transparency – making elements appear and disappear based on user selections. Based on the selection of countries, we are looking at differences in foreign
2026 Week 10 | Power BI: Dynamic visibility of visuals Read More »
Power BI, Workout Wednesday
Introduction We’re going to try something a little different this week. We’re going to make a viz/dashboard without a dataset. Having just come from my daughter’s Christmas show this evening, and thinking I wanted to focus on container/dashboard formatting but keep it simple, I decided to build, then decorate a Christmas tree. So, that’s what
#WOW2024 Week 50: Can you build a Christmas tree? Read More »
Tableau, Workout Wednesday
Introduction The challenge for this week is to first build a scatter plot of fertility vs life expectancy of different countries. However, this will not just be for a single year, but will contain information across many years, making it possible to slide the year and see how all the bubbles move. The key challenge
2024 Week 27 | Power BI: Scatter plot showing the path of selected data points Read More »
Power BI, Workout Wednesday
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
2024 Week 14 – Timeseries in CRMA! Read More »
CRM Analytics
Introduction In this week’s challenge we are creating an Overlay Histogram. An overlay histogram utilises overlapping columns or bars to compare two populations. In this case, we are utilising the speed dating data from a previous challenge to compare male and female differences in dating preferences. Requirements Obtain the data from the Workout Wednesday 2022
2024 Week 13 | Power BI: Overlapping Histogram Read More »
Power BI, Workout Wednesday
Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations
2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More »
Power BI, Workout Wednesday
Introduction The Christmas Season is upon us and with that we bring you one last collab for the year – the Preppin’ Data team is back with a festive challenge for you all. The goal of that challenge is to get the data Tableau-ready. You will produce two outputs which are both used in this
#WOW2023 | Week 51 | Elf Economics Read More »
community, Tableau, Workout Wednesday
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 »
community, Tableau, Workout Wednesday
Introduction Conditional formatting is a robust feature in Power BI that you can leverage to help users gain insights. Typically, we see conditional formatting applied to the table and matrix visuals. For example, you might apply a background color, font color, or icons to the values based on a set of rules. Conditional formatting of
#WOW2022 W43: Advanced Formatting by Jeremy Anderson Read More »
community, Power BI, Workout Wednesday