2023 Week 32: Can you show all values when filtering?


This week we have a special guest, Venkatesh Iyer. Venkatesh is currently a Senior Analytics Consultant at phData–and has recently written a number of blogs that bring novel solutions to the community, including:

Venkatesh brings creative, performant solutions to everyday problems in Tableau, so I invited him to share a challenge. And I think everyone will enjoy this week’s challenge


  • Dashboard Size: 1000 x 800px
  • At least 2 sheets (can be done with 3 as well)
Quarterly Bar Chart
  • Create a bar chart that shows either Sales or Profit (depending on what is selected) by quarter of Order Date
  • Add labels on top of the bars
  • The color of the bars should dynamically update depending on whether Sales or Profit is selected
Customer Bar Chart
  • Show Sales and Profit by Customer Name
  • Make sure the Profit and Sales bars should be different colors match the quarterly bar chart (depending on the measure selected)
When you select a bar on the Customer Bar Chart, the Quarterly Bar Chart should…
  • Update to the measure that is selected
  • Filter to the customer selected
  • show 0s for quarters where customer have no sales/orders.
  • Update the header to show the customer name above the Quarterly Bar Chart.
  • Match the formatting


This week uses the latest superstore dataset. You can find it here on Data.World


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 #WOW2023 in your description to make it searchable!


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



Scroll to Top