1 of 1 people found this helpful
Not sure I know of a way to do exactly what you're asking for but would a floating drill down with a hover action starting blank accomplish what you're looking for? Something like this:
Yes that's exactly what I'm looking to do. I'm going to download it but in your own words, how did you do it?
Nolan -- I have downloaded this. It's fascinating and I'm trying to dissect it. I posted this here to get a ping when you respond to Matt.
So this solution works in this case because the request was to only show the top 5 of each category so we can get away with using a fixed size floating worksheet.
First for the top 5 list, I set my a text table up showing product category then product. I then sort by profit and create an INDEX() restarting every product category. I think filter the index values to only display 1 through 5 for each category. I hide the product category and index values and leave only the product name and profit measures.
I then create the bar chart of product category. Throw both of those worksheets onto a dashboard. I then floated the text table and removed the title. Then instead of using the default "Use as Filter" option, I created a custom filter triggered by hovering and set the option to clear all values when the filter is removed which allows you start with a blank filter. Then it is just a matter of moving the floating (and now blank) text table to a place that makes sense.
Hope that is helpful but let me know if either of you needs more information.
"... filter the index values to only display 1 through 5 for each category..."
That is what I was missing. I was trying to figure out how you limited to just 5, and I didn't consider the obvious: manually setting the filter.
Your viz is a very clever use of features. I'm putting this idea in my bag of tricks.