Drill down using controls in the dashboard

Question & Answer
1

My question is we have drop down controls in our dashboard and we want to perform a drill down using controls
for example If I want to drill down from Country to State to City to Street using controls ,
so as we drill down we want for example the bar chart to drill down to what is selected in the control

We saw you can use actions but than actions require you to click on a visual to drill down and we dont want that we want to drill down using controls
We tried using calculated fields but it was too manual as we had to do multiple if statements with parameters is there a dynamic way of doing this? Please assist?

2

Yes this can be easily done using Parameters and Controls, to dynamically select individual dimension for drill down instead of clicking on bar graph.

a good working example is demonstrated here which you can go through https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures