If you have a chart visualizing your sales data per year, you might want to give your end users the possibility to drill down in time to get more into the details. Or if you have a chart visualizing your sales per product group, it might also be handy for your end users to get more information on the lower levels like sub-group or the individual products themselves. You can even drill down over different columns and data types, datetimes and/or hierarchies!
If you are looking to change the measure or dimension in the chart, rather than to drill down, the Measure & Dimension picker is what you are looking for!
In the chart settings underneath the ‘Interactivity’ tab, you can toggle on ‘Drilldown’ and edit from here. You can choose the name displayed for the drill down path you are building and you can choose the columns and levels to be part of the path. You can set up one or multiple drill down paths which can each be traversed by the end user.
Click the blue button Save to complete the process.
Once the function is activated, dashboard users can easily use it by clicking on the part of the chart they want more details on and selecting a level. They can return the chart to it's full range by clicking on breadcrumb icons that appear on the top left of the chart.