To do a drill-down easily, you can create a hierarchy. Click-and-drag any dimension onto another one to start creating it. When you put this hierarchy into the colors mark (or certain other places), you'll see a little + button in the pill that will allow you to drill down.
Hi and thanks for your answers. I'm not sure if i'm not getting it but....
In a Dashboard I would like to see Categories (like your first image) and on the Dashboard I would like to be able to click on a bubble to see only it's sub categories .....and then go back with one click.
If i am understanding correctly, you are requesting to see the drill down based on clicking on the viz. For that, you have to create two worksheets and put them in a Dashboard and using actions for interactions.
Attached is the sample workbook. Please let me know if this helps.
Step 1: Create worksheet with a bubble chart with categories
Step 2: Create another worksheet with a bubble chart for sub categories
Step 3: Create a Dashboard for with each worksheets on it.
Step 4: Create a Actions --> Source and Target as shown in attachment.
Also have added a placeholder Calculated field and Worksheet which are hidden, to show as link for user to move back and forth between these two dashboards.
Drill Down Bubble.twbx 1.2 MB