How to use drill through in Power BI: set up a details page so one click on a chart shows the data behind it. Plus how to add a drill through button.
🔥 New to Power BI? Start with our free Power BI QuickStart course: https://link.xelplus.com/yt-d-drill-powerbi-starter
⭐ Ready to go further? Join Fast Track to Power BI: https://www.xelplus.com/course/fast-track-to-power-bi/
The example is a sales report by store. You'll see how to create a details page, add the store name as the drill through field, and drill through from the tooltip or with a right-click. The year and store you selected carry over to the details page automatically, and Power BI adds a back button for you.
You'll also see how to show store flags and manager photos with the Image URL data category, set up more than one drill through page, and add a drill through button that stays grayed out until a store is selected. Drill through is also written drillthrough in Power BI.
In Power BI Desktop, hold Ctrl and click to use buttons.
★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses
✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter
00:00 What is drill through in Power BI?
01:12 Example: sales report by store
01:47 How to create a drill through page
03:01 How to add a drill through field
04:12 Drill through from tooltip or right-click
04:39 How drill through filters carry over
05:07 How to add a multi-row card with store info
05:58 How to show images in Power BI (Image URL)
06:22 How to add multiple drill through pages
07:05 How to add a drill through button
08:00 Why the drill through button is grayed out
08:24 How to format button states in Power BI
🎬 Related videos:
Should You Learn Power BI?: https://youtu.be/7ZMQZ0UUuTs
How to Use Microsoft Power BI: https://youtu.be/c7LrqSxjJQQ
🚩 Connect with us:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/in/leilagharani
#powerbi #powerbitutorial #drillthrough
