Within this tutorial, we explore the SharePoint Chart Drill Down capabilities to display more detail within the chart. There are multiple drill down options including displaying another chart place or as a pop up, navigating to another page to display more detail such as a BCS External List, or navigate to a page passing through a query string variable allowing results on the target page to be filtered.
The SharePoint Chart Drill Down options can be found towards the end of the configuration dialog and allow users to configure one of five options. The example that we use within the video is to display sales figures per quarter within the chart. If you want to then show sales figures per month, you can click onto the quarter in question, and the chart will change dynamically to show sales figures for the three months within that quarter. Click a month, and the SharePoint chart drill down will display sales figures per day.