I love how this also works with other parameters to populate the sub-values! My use case is wanting to see the overall category distribution while drilling into a sub-category distribution where the sub-category varies depending on its parameter selection. So now I can drill-down by a variety of dimensions. So great, thank you!
Thanks for this wonderful trick. Can we change the color for sub categories e. g when I click on category (furniture) then sub categories come up with different color, that will make easier to understand with other category.
Andy Thanks for this time-saver idea, brilliant! I, however, have issues wherein the action won't work on the tableau server, it works fine on tableau desktop
Hi Andy, this is fantastic..I'm able to do this for one level but struggling to understand how to apply the same concept when there's multiple levels that I'd like to drill down. Can you give us an example? I don't use set actions because the table shows blanks when not clicked, so parameters look a lot cleaner when using a table view.
Hi Andy, Would it be possible to do multiple drill downs? For example Category to sub category and then sub category to sub category 2 ? If yes, how exactly?
Hey Andy, this video was really helpful, but I am facing a problem, when I am integrating this graph in a dashboard drill down is not working, do I have to some changes in dashboard as well?
Thanks for the tip Andy, I do have a problem with the sub category list being too long (50+) on some selection. So it all cramped up in Dashboard view when I click on the selection, what can I do to resolve this please?
Great stuff Andy! Is it also possible to select multiple categories for drill-down`? Right now it only works for one but what would need to be done to make it work for multiple?
@@vizwiz Thank you but I can't see that option. I have tried it in version 2020.4 (where I was building it) and also 2021.3 (just updated) but nowhere I see that option in the "Actions" menu?
@@daplaya20 oh this is dumb of me. I was describing how to do it with a set action. A parameter cannot hold more than one value, so it won't work. You will need to use a set action instead. I think this video has the way to do it with a set action. If not, let me know. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d0jJrMbiFsM.html
Thanks Andy, is it possible to drill down with measure values? I have created some measures, but I would like to include the calculations that made that measure. i.e rate drill down to the questions that created that rate?
Hi Andy, I don't see Nested sort option as you have shown in video (@ 1:53) and also don't see in add actions drop down "Add Parameter Actions". where am I going wrong?
I just saw Kumar's same issue - see my first comment below. I then recreated a separate actions and now it works. THANKS I did this and have it working in the Worksheet, but when I put it in a Dashboard it did not work. I did got to Dashboard Actions and checked 'Show actions for all sheets in this workbook." What did I do wrong?
Hi Brenda - You can make your Worksheet Action function on a Dashboard by changing the way you originally set it up. In the Action’s settings change the Field, Source Sheet, from the Sheet to your Datasource. This will make the Action function on your Dashboard and prevent you from having to recreate the Action on your Dashboard. Hope this helps!
Hello, thank you for this video I have two questions : I am trying to make a treemap with 3 levels (categories, sub-categories and products), and a filter at the more detailed one. When I deselect a product, I want it to come back to the categories treemap level. I think it is pretty much the same as your example. But I have a problem, the drill down is working with a table, and not with the treemap. Any idea of why ? The second problem is that I can’t hide the categories/subcategories when they are not selected. I tried with an action filter but it didn’t work. Is there a technical way to do that ? Thanks in advance for any help
I'm not sure why it wouldn't work. It must be something to do with the treemap. A treemap is incredibly difficult to understand, so I'd recommend going with a bar chart anyway.
Hi Andy, I have a requirement where on clicking technology I need only the corresponding subcategories whereas Furnitures and office supplies must be hidden. Is there a way to achieve that?
Hi, can it be possible to just show the subcategories of the specific category and not show the other catgories. and also if we can put the name of the category on top of the mention subcategories and show the total value while the break down of values below in front of remaining subcategories
Hello, great vedios ..I am learning a lot..I just need one help..could you show same drill down in line charts for trends? I am unsuccessful in doing so
@@vizwiz Hello Andy, I would like to have one line chart with multiple categories,if I drill I should get all manufacturers,further if I drill I should get all the brands,further sub brands...all in one chart...is it possible? I got a project to do so and I am not able to do it 😩
@@vizwiz Yes its indeed very complicated..I am still a beginner and learning a lot from your videos. It's just awesome. Could you kindly share the link if you have for that or is it possible to make a video on that...it would be of great help.
Can this be also used in a time series drilldown instead of creating a set action drilldown? (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ICbXLgYvcWo.html)