I have given a challenge by an end user to provide a bubble chart that can be interacted with.
I have created my bubble chart and I have put the custom hierarchy on the label pill and works as required if I expand on it. The use case is to be able to filter at a higher level and then drill into the underlying members.
My issue is that once i put the worksheet into a dashboard, there is no way that I can see to interact with this as required.
Hopefully someone has worked out how to do this.
My fall back solution is far from ideal and consists of two bubble charts side by side and two parameters that allow a very clunky navigation.
Many thanks if you can assist me on this.
I understand that Joe Mako is a bit of a legend with these things and likes a challenge ..... ;-)
Andrew
Mock something up using the Superstore data set and post a packaged workbook, and I'll take a look.
--Shawn
