SVG Pictrogram

2023 Week 32 | Power BI: SVG Pictogram

Introduction This week’s challenge was inspired by FiveThirtyEight’s Nobody had more style than Jay Wright created by Ryan Best For this week’s challenge we will be creating SVGs with shape elements that are coloured dynamically based on field values. Create your own SVG and add your own flair to this design. Requirements Obtain the source data …

2023 Week 32 | Power BI: SVG Pictogram Read More

A shot of a dashboard and bar charts

2023 Week 32: Can you show all values when filtering?

Introduction This week we have a special guest, Venkatesh Iyer. Venkatesh is currently a Senior Analytics Consultant at phData–and has recently written a number of blogs that bring novel solutions to the community, including: How to improve the performance of count distinct How to Create a Drill Down Table in Tableau How to paginate in …

2023 Week 32: Can you show all values when filtering? Read More

2023 Week 31 | Power BI: Create a Marimekko chart

Introduction Inspired by a Tableau Workout Wednesday from last year, we are going to make a Marimekko chart. A Marimekko chart, also known as a Mekko chart or mosaic plot, is used to visualize categorical data across two variables. Both axes use a percentage scale that determines the width or height of a bar. Think …

2023 Week 31 | Power BI: Create a Marimekko chart Read More

#WOW2023 W31: Can you find the most popular sub-category by sales per state?

Introduction I am a big fan of Level of Detail calculations and this one is an oldie but goodie! That is the main focus this week, but also uses Parameter Actions & Viz in Tooltips.  Click to open in Tableau Public Requirements Dashboard Size: 600 x 600 Two Sheets Find the most popular sub-category by …

#WOW2023 W31: Can you find the most popular sub-category by sales per state? Read More

2023 Week 30 | Power BI: Build a smooth line chart

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

Scatterplot of profit on Y Axis and sales on X Axis, with a dot for each state, colored by profit ratio.

WOW2023 Week 30: Can you build a dynamic drill down scatterplot in one view?

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

Waffle chart created with core visuals

2023 Week 29 | Power BI: Core Visual Waffle Chart

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

Scroll to Top