2022 Week 20 | Power BI: Pie Matrix Tableau Redo

Introduction

May is Tableau Redo month and this week we will be recreating Tableau #WoW2019 Week 45 by Luke Stanke.

 

Requirements

  • Filter the data up until November 6th, 2021.
  • Create a matrix showing region and last 7 days (up to November 6th, 2021).
  • Create SVG Measures to build a doughnut chart that shows the percentage of orders that have been shipped as of November 6th, 2021 by day and region.
  • TIP: Visit the Quick Measures Gallery for a template to work from.
  • If 100% of orders have been shipped show a green dot with a checkmark.
  • Show aggregates for the last 7 days.

Dataset

This challenge uses the Tableau SuperStore dataset provided on data.world. You will need to log in to data.world to retrieve the data, but accounts are free. 

Or you can download the PBIX from the Data Stories Gallery

Share

After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year. 

Solution

7 thoughts on “2022 Week 20 | Power BI: Pie Matrix Tableau Redo”

  1. Hi,
    using one of the Quick Measures Gallery as an example, I managed to create similar ( a pie not a doughnut). Can’t wait to see how you’ve done it.

    1. Hi there! video is now available (link above). I’ll be working on improving the quality of the video and audio in future…

      1. I used a plain white circle to make the doughnut hole, but clip-path could be used to create a transparent segment.

Leave a Reply to John Cancel Reply

Your email address will not be published. Required fields are marked *

Scroll to Top