Introduction
Welcome to week 9 – and just like that we’re already welcoming March 🚀.
I’m so excited to be partnering with fellow Kansas Citian & Tableau Visionary, Felicia Styer, for this week’s challenge. Recently she created a framework for what she calls “binary parameters” which allows for a solution for multi-select parameters.
The goal is pretty simple click a bar to add, click same bar to remove. no menu actions, no sets, just clicks.
Let’s go!
Requirements
- Dashboard Size: PowerPoint (1600 x 900)
- Create a bar chart of Sales by Subcategory.Â
- Create a dimension that ‘buckets’ subcategories and add that dimension to the color property.
- Set up an action that changes the bucket assignment.
- When a mark in bucket 0 is clicked, it moves to bucket 1.
- When a mark in bucket 1 is clicked it moves to bucket 0.
- Note, if a mark is already selected, it might require an extra click!
- This build involves one string parameter, with no sets or groups.
- Do it without hard-coding any subcategory values
- Add a second bar chart showing the total sales for each bucket.
- Create a version with 3+ buckets.
Dataset
Standard Superstore datasource. Available 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 #WOW2025 in your description to make it searchable!
Share
After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2025 #Tableau and tag @WorkoutWednsday
Solution
Interactive
