Welcome to Episode 8 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create drillthrough pages in your report.
Here we go!
Create Drillthrough Pages with Detail
Drillthrough pages allow for your users to navigate to different pages within your report to expore the details of the visuals that they choose. For example, you can create a drillthrough filter in Power BI based on the specific entity.
After you create the drillthrough pages, be sure to mark them as hidden. In this case, the users will not see these pages in your dashboard. However, they will navigate through these drillthrough pages by simply clicking on the visuals. Also, make sure that your drillthrough pages include the back arrow to easily navigate to the previous page.
Check out our prior episodes to see where we are going and discover what BEST PRACTICES for Power BI is all about.
- Prepare report requirements
- Relate tables using your data model
- Align the visuals
- Create drillthrough pages with detail
- Themes are your best friend
- Include a report support tab
- Cut unnecessary visuals
- Edit interactions
- Set visual, page & report level filters
Let’s continue the discussion
In the meantime, I’d love to hear your feedback and stories on how you go about storytelling with Power BI. Feel free to connect with me on LinkedIn or Twitter @thepowerbiqueen. I’ll be watching the #PowerBIQuestions hashtag, so feel free to ask any questions, and I’ll try to get you some answers.
Thanks!
DeNisha Malone
