The Drillthrough feature in Power BI functions as an indicator for a Power BI Report. With Drillthrough in power bi report, you can create a destination target page in your report. When report viewer right-click a Data point in other pages, they drillthrough automatically filtered to that context. You can set up drillthrough in your reports in your power Bi Desktop or Services.
Step-1: Create a Table visual to using Customer Name, category, Sub-category & Sales fields, this is Main Page .
Step-2: Now Create a another page for Drillthrough data, in that page drag on Clustered Column chart and display the below fields.
Step-3: Now drag the field for which you want to show with drill through function into the Drill Through Fields.
Step-4: Add one blank button to main page for using Drillthrough function with Button> Go to Insert Tab > Click to Buttons > select Blank Button.
Step-5: Now select button & assign the name to button & set the basic format colors and shape . And don’t forget to select Action> Type : Drill through & Destination: Page Name.
Step-6: Now select any Customer Name, Category & Sub category & click to button to using Drillthrough function Ctrl+ Click
Step-7: Output of selected Data.
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at firstname.lastname@example.org or Contact us.