#Tableau - 2-Level Drill Down Action

There are tons of ways to create a single level drill down, but if you’re having issues creating a second drill down, this video is a guaranteed way to help you fix this problem.

5:36 Demo of solution - then go back to the start

[winterhalter]

Hey! I started as a data analyst 3 weeks ago. Your channel is a gold mine for me :)

[menschnars]

Thanks as always Andy! You've come a long way from the "Tableau Tip Tuesday" Days:) Keep up the good work!

[peterphillips]

Hello Andy, I just used this technique on a dashboard and it is great. I added some space to the beginning of the string in 'c. Level 1 Drill' as below

If [Category] = [p. Level 1] THEN ' '+[Sub-Category]
ELSE [Category]
END

I then changed 'c. Level 2 Drill' to add an LTRIM to one side of the comparison

If [Sub-Category] = LTRIM([p. Level 2]) THEN [Region]
ELSE ''
END

The result is that you get a slight indent to the Sub-categories for the chosen category.

[ngquocthang]

Top notch editing, I love the new style. Love from DS Down Under

[ramu]

Thank you for your exceptional contribution to the community 👋

[TheElectrocar]

Tableau has been around for 20 years and this still isn't an out of the box feature.

[wolfsburgi]

Your teaching using the superstore is fantastic and accessible even for someone like me who is learning almost on my own.

Even though I'm not fluent in English, I'm learning a lot from your lessons at my job and I'm learning more and more, thank you very much.

[CesarGarciaJara]

Great, great video.
Of course now I have to spend a couple of hours recreating and playing around with it.
I am all set for the weekend!!! 😆😆😆
Thanks a lot for your videos.

[suwannahansuwat]

Exactly what I am looking for. Thank you, Master Kriebel!

[eddyjo]

I was trying to implement that for a long time with set but could not. Here is finally how to do it, not even with set.
Thanks a lot.

[yosephfahed]

He's by far one of the best if not the best. The only issue is he is a bid too fast. Thus, amazing techniques.

[williambeasley]

Thats awesome!! I could not figure out how to go down more than one level. I need to go down 4 levels... wish me luck!!

[abhishekkurri]

Andy, Thanks for making this video. Your tips and tricks are awesome. :)

[jawadahmad]

Thank You so much Andy. I was looking for exactly this same thing. I halve learned a lot watching Yours videos. 🙌👌

[shaquellejacobs]

I created a 7 level drill down. I can’t reverse so I use undo button to reverse. I used set actions

[briannaalvarez]

How does one add this to a dashboard? When I insert the sheet into my dashboard, the bars don’t drill down 😢

[kxshmlc]

hi sir how we can exclude rest of the columns, only selected should shown

[kinnokchan]

neat teaching and a very useful skill to have. I found that you tried to add more aesthetic elements in video as well. very enjoyable to watch :D

[djmenon]

Lovely video Andy...just one simple doubt @2.13 I see there were 2 fields (Category, Level 1) both showing Furniture, Office Supplies and Technology...how did you hide the duplication of the Rows? because at 2.19 its showing you have Category and Level 1 but in the view I can see only Level 1 showing and Category has been hidden

[_aidenbailey_]

Hi Andy, thanks for the tutorial! I'm having an issue where the region is showing up under all the categories, not just the selected one. Any advice on how to fix that?