Which version of tableau are your using?
Its very much possible using #SetActions which is available from v2018.3 and above.
Follow this sample, click on category lable to drill down/up
Let us know if this help.
what I am actually looking for is when I click on 2018 (in the sample you provided) then all other data hides and only the quaters for 2018 are shown and when I further click on a quater the all the months belonging to year 2018 and that particular quater appears not other columns
That also is doable...its all about how you construct the set action and how you want to show/hide the underlying values from the view.
If you can share some sample mock up data in packaged workbook then we can give some solution
I've made a Bar Chart in Sheet & displayed it in the dashboard.
Please let me know if it is possible to get quarter, week etc (Drill Down) by selection of any year from my Bar Chart itself.
Similarly, if I want to show sub-categories of any category by clicking on a category from the chart itself.
Test.twbx 8.2 MB