17.4 Using Drill Through
Steps in Power BI – from the City Summary page
- On City Summary, build a bar chart: Y-axis = Store Name, X-axis = Total Orders, with a City slicer set to Pune.
- Right-click the Blinkit Kothrud Hub bar › Drill through › Dark Store Details.
- The target page opens, filtered to that store. Check the drill-through filter card in the Filters pane.
- Click the Back button. In Desktop, hold Ctrl while clicking buttons. In the Service or in Reading view, a normal click works.
Drill-through button (more discoverable than right-click)
- Insert › Buttons › Blank. Set Format button › Button › Action = On, Type = Drill through, Destination = Dark Store Details.
- Button › Text: "Select a store, then click for details". Use fx on the text so it says
"Click to see " & SELECTEDVALUE(DarkStore[Store Name]) & " details"when a store is selected. - The button is disabled until the user selects exactly one store in a visual. Style the Disabled state (grey) and add a Disabled tooltip text such as "Select one store first".
Ravindra Bagale's Tip
Friends, many students forget the Back button, which leaves users stuck on a hidden page. Power BI adds one automatically when you set up drill through; keep it, place it in the same spot on every detail page, and test the full path as a user would. This matters for both exams and interviews.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students Back button विसरतात, त्यामुळे users hidden page वर अडकून पडतात. Drill through set करताना Power BI आपोआप एक button जोडतो; तो ठेवा, प्रत्येक detail page वर त्याच जागी ठेवा, आणि user जसा वापरेल तसा पूर्ण path test करा. हे exam आणि interview दोन्हीसाठी important आहे.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students Back button भूल जाते हैं, जिससे users hidden page पर अटक जाते हैं. Drill through set करते समय Power BI अपने आप एक button जोड़ता है; उसे रखो, हर detail page पर उसी जगह रखो, और user की तरह पूरा path test करो. यह exam और interview दोनों के लिए ज़रूरी है.