Showing lots of details in one page of BI report is usually not a good idea, to provide a better experience for report viewers, users have to create multiple pages of different visuals in their reports. This can solve some problems of telling a story about data but it is much more useful if users be able to have some kind of connection between these pages to tell a continuous story.
For example imagine a report with page of visuals about total sale of products, if user wants to get into detail sales of each specific product they need to create another page in their report to show details about that. Without having a proper connection they cant transfer the selected product to details page. They have manually do this every time they want to show details of a specific product.
This scenario helps them to create this connection in an easy way, just by selecting a product in their page then can easily get more details about that specific products with two mouse clicks.
We started by running multiple user research on a prototype that I created with Axure. In this concept we added a drillthrough button in ribbon as an entry point, after clicking that users see a modal box which they can define source, target, fields they want to send and a name.
We tested this prototype to find answers to these:
You can see a sample process of creating a drillthrough in this prototype demo:
Here are 4 other concepts that we tested:
Based on users feedback on different concepts that we tested, it was obvious that users preferred the drillthrough bucket in filters pane since the approach is almost as same as adding other filters to their reports and they already knew this process.