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