#WOW2024 | Week 19 | Can you expand this segmented bar chart?

Tableau, Workout Wednesday / By

Introduction

So this week follows on from my previous challenge in week 13 here. Feel free to either recreate completely from scratch or use my/your own original solution to build on (my solution for week 13 is here and my solution guide is here).

Having built a segmented bar chart, we are now going to add functionality to expand each row, to get a clearer idea of how the annual sales displayed in the stacked bar part of the initial chart, compare against each other.

Click to open in Tableau Public

Requirements

  • Dashboard 1000 x 800
  • Add arrow indicators to signify whether the Sub-Category row is collapsed ► or expanded ▼
  • When expanded, display the Sales by Year as a horizontal bar chart, ordered by Year immediately below the Sub-Category that has been selected
    • Display the labels for each year, all aligned to the right.
    • For each year that is less than the maximum annual sales, show a thin line that extends to the maximum.
    • Display the expanded section in a different background colour from the main chart.
  • When a section is expanded, ensure the scale of the of the total sales displayed remains in line with the unexpanded chart eg when expanding Copiers, the bars from Bookcases downwards should still be shorter in length than Copiers.
  • Ensure the user can click once to expand and then click once again to collapse, or click another row to expand that one instead
  • Match formatting & tooltips; choose your own colours if you prefer – I used #dec7b6 for the bars and #fefaf1 for the background
  • Hint – I used some of the techniques described in this blog https://www.phdata.io/blog/how-to-build-expandable-tables-with-zone-visibility-in-tableau/

Dataset

This challenge uses Superstore 2024.1 which is accessible from here

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2024 in your description to make it searchable!

Share

After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday

Solution

Can you expand this segmented bar chart?

Interactive

Scroll to Top