Tableau Challenges #7 Link Tableau Challenges Solutions #7 Link
Join the Vizuators team!
Website: https://vizuators.by/ Telegram: https://t.me/viz_techreview Tableau Public: https://public.tableau.com/app/profile/vizuators.challenges Youtube: https://www.youtube.com/c/Vizuators Instagram: https://instagram.com/vizuators Facebook: https://www.facebook.com/vizuators.by/ Twitter: https://twitter.com/vizuators LinkedIn: https://www.linkedin.com/company/vizuators
Abstract author: Ekaterina Kalabush
Show the next hierarchy level only for the selected department
Step 1: Create a bar chart. Drag Sales (SUM) to Columns, Department to Rows.
Step 2: Create a Parameter Choose Department as in the screenshot below.
Step 3: Create a Calculated Field Show Category Detail. In simple words: if the department is equal to what is selected in the parameter, then the category will be shown, if there is no match, then nothing will be shown.
IF [Department] = [Choose Department] THEN [Category] ELSE "" END
Step 4: Drag the Show Category Detail pill to Rows. You can already use the parameter to select a department.
Step 5: Let's make it so that the user can select the department directly on the chart. To do this, go to Worksheet → Actions. Next, click on Change Parameter. And configure the parameters, as in screenshot 2
Done! Now we can see detailed information for the selected department.