I have solved your Query as you asked, Since directly you cant filter out the things like you want. The "Menu Filter" will Solve your Purpose.
I am attaching the Workbook (Version 10) as well as some screenshots.
Please see to it and get back to me for further queries.
Hope this helps.
Superstore.twbx 350.6 KB
Hi Rahul verma,
Thank you for taking your time in doing this.
I am aware of the above method of menu actions.
But the requirement here is to let it filter and take it to the appropriate dashboard. This is a mock-up data . In reality i have five bar charts .
Do you think it is possible in tableau the way i want it to be ?
Please find the attached version. However I could not achieve exact same effect as you desire but close to it. I have restructure data to get the results.
See if this is possible in your scenario.
SuperMockup.twbx 20.1 KB