Power BI Tricks – Drillthrough

Drillthough allows you to view a report page for specific detail. For example, you can have a 2 page report

  1. Page 1 with overall business summary
  2. Page 2 with store level performance details

With drillthrough on page 1, when you select a store, you can view Page 2 for that store.

Drillthroughs are easy to setup and use in Power BI. In this lesson, we will use Retail Dashboard casestudy to create a drillthrough functionality and store performance report.

Related links:

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.