2022 Week 45 | Power BI: Ribbon Chart (Advanced)

4 Comments / Power BI, Workout Wednesday / By

Introduction

Another Deneb visual this week – creating a custom Ribbon Chart.

 

This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a survey.

 

This week will be a little more advanced than previous Deneb exercises, so it has been broken down into time commitments.

 

QUICK, NOT SO QUICK, LONGER, ADVANCED

 

Download data from YouGov or a choose another survey question of your choice.

 

Happy Vizzin’

/\___/\
|= ͡° ᆺ ͡°)=
\╭☞ \╭☞ CHECK!

 

 

Requirements

QUICK

  • Import Deneb visual from AppSource
  • Place the appropriate fields into fields well.
  • Select the Deneb visual, from the ellipsis select edit visual
  • Create an area mark, set “interpolate” : “monotone”, “tooltip”: true
  • Encode Date on the X-Axis
  • Encode percentage of responses on Y-Axis
  • Encode colour by category
  • Encode order by percentage; “order”: { “aggregate”: “sum”, “field”: “percent”, “type”: “quantitative” }
  • Save and close

NOT SO QUICK

  • Set Y-Axis to false
  • Encode Date on the X-Axis, with “zindex”: 1, and in the config section set “gridColor” : “white”
  • Set legend to false
  • Layer series text mark labels to the right of the last data points
  • HINT :

“transform”: [
{  “window”: [   {“op”: “rank”, “as”: “rank”} ],
“sort”: [  {   “field”: “Date”,   “order”: “descending”  }  ]   },
{“filter”: “datum.rank === 1”}  ],

  • HINT : “stack”: “zero” in Y-Axis encoding 

LONGER

  • Update Axes to show yearmonth with multi-line labels
  • Layer stacked bars with white outlines on the first and last dates
  • Set opacity of area marks to 0.2

ADVANCED — EXTRA CREDIT

  • Use params to update opacity of area marks to 0.7 upon hover
  • Set gridlines to null
  • Layer thinner stacked bars across all dates
  • Set opacity of bars to 1 upon hover, else white
  • Add data labels for rank and percentage upon hover

Dataset

This challenge uses data from YouGov here:  https://yougov.co.uk/topics/relationships/trackers/how-brits-meet-their-partners 

Or you can download the PBIX from the Data Stories Gallery : Workout Wednesday 2022 Week 45 – Microsoft Power BI Community

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. 

Please be sure to cite source before sharing.

Solution

Coming Soon

 

4 thoughts on “2022 Week 45 | Power BI: Ribbon Chart (Advanced)”

  1. Jan Kincl

    Hi,
    I tried to do the challenge but I got stuck. Is there going to be a video “tutorial” published for this challenge by any chance? 🙂 I am pretty new to WOW and haven’t used Deneb at all yet.

    The video linked in the Watch section is for Week 20.

    Thanks

    Jan

  2. Kerry Kolosko

    Hi, yes there is a video tutorial in the making – it has been delayed. If you haven’t tried Deneb yet, I’d recommend getting started with some of the other Deneb WoW challenges from previous weeks.

  3. vuongha

    waiting for your solution, this is a wonderful chart but up to now i still can not know how to create thats, thank for your share

Comments are closed.

Scroll to Top