Sometimes clients ask for details when clicking on the specific field in the visual of the report page. One of the best ways to show it without putting lots of space on the main page is Drill Through in Power BI reports.
In this post, I will show an example of using the Drill Through in the report.
Start by creating the details page to show more details to clients about the main Category they will select. So I gathered all possible details on one page based on Categories and named it “Category details”:
Once the details page is ready, fix the page instead of standard –> Drill Through and select the data based on the Category filter. The top left corner of the page’s back arrow will be created by default:
Then on the main page in each category selecting “Drill through” will appear:
If you want to use left-click for this purpose then active the “Drill Through” on the top ribbon and then use the Category Drill Through selecting:
If you use “drill through” in your Power BI reports, comment below.
Atefeh BI 