Forum Discussion
Need help " Power BI Desktop
Hello,
I have a drill through page(DT 1) which filters project details. Now i want to drillthrough from DT 1 to see more details about that project in DT 2.
How can i achieve this?. Please help me.
Hi Ramesh4321 - To drill through from Drill Through Page 1 (DT 1) to Drill Through Page 2 (DT 2) in Power BI while maintaining the context of the project details
Open DT2 Page:
Navigate to your second drill-through page (DT 2) in Power BI Desktop.In the right-hand pane, under the Visualizations section, find the Drill-through section.Drag the field you are using to identify the project (e.g., Project ID, Project Name, or Project Code) from the fields pane into the Drill-through area.
Make sure this is the same field you are using in DT 1 for filtering project details.Below the field you added for drill-through, there is an option to Keep all filters. Enable this to ensure that all other filters applied in DT 1 (such as date ranges, regions, etc.) are passed to DT 2 when drilling through.Make sure DT 2 is set up to show the additional details you want to display after drilling through from DT 1. Ensure that visuals in DT 2 are responsive to the project filter being passed from DT 1.
Point2:
Goto DT 1:Navigate back to the first drill-through page (DT 1) where you want to drill from.
Set Up Drill-Through Action:
- Select a visual or a table on DT 1 that shows project details (e.g., a table with project names, IDs, or summary).
- When you right-click on a specific project in this visual, a Drill-through option will appear. You should now see an option to drill to DT 2.
Test the interaction
In DT 1, right-click on a project in the visual and select the Drill-through option, then choose DT 2. Power BI will take you to DT 2, showing more detailed information about the selected project, with any other filters from DT 1 retained.
You can use the back button provided by Power BI to return to DT 1 after drilling through to DT 2. hope your data model supports the relationship between the project filter on DT 1 and the detailed data on DT 2.
DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL (youtube.com)
Cross-report Drillthrough in Power BI (youtube.com)
--Set Up the Drillthrough for DT 2:
Go to DT 2 and add a field to the Drillthrough Filters section (like Project Name or Project ID). This will allow you to pass the project context from DT 1 to DT 2.
--On the DT 1 page, when a user right-clicks on the project detail visual, they will be able to select Drillthrough > DT 2.
This will take them to DT 2, with the same project context passed along.--You can add a "Back" button to DT 2 to let users navigate back to DT 1 by using the Insert > Button > Back option.
2 Replies
- rajendraongole1
Super User
Hi Ramesh4321 - To drill through from Drill Through Page 1 (DT 1) to Drill Through Page 2 (DT 2) in Power BI while maintaining the context of the project details
Open DT2 Page:
Navigate to your second drill-through page (DT 2) in Power BI Desktop.In the right-hand pane, under the Visualizations section, find the Drill-through section.Drag the field you are using to identify the project (e.g., Project ID, Project Name, or Project Code) from the fields pane into the Drill-through area.
Make sure this is the same field you are using in DT 1 for filtering project details.Below the field you added for drill-through, there is an option to Keep all filters. Enable this to ensure that all other filters applied in DT 1 (such as date ranges, regions, etc.) are passed to DT 2 when drilling through.Make sure DT 2 is set up to show the additional details you want to display after drilling through from DT 1. Ensure that visuals in DT 2 are responsive to the project filter being passed from DT 1.
Point2:
Goto DT 1:Navigate back to the first drill-through page (DT 1) where you want to drill from.
Set Up Drill-Through Action:
- Select a visual or a table on DT 1 that shows project details (e.g., a table with project names, IDs, or summary).
- When you right-click on a specific project in this visual, a Drill-through option will appear. You should now see an option to drill to DT 2.
Test the interaction
In DT 1, right-click on a project in the visual and select the Drill-through option, then choose DT 2. Power BI will take you to DT 2, showing more detailed information about the selected project, with any other filters from DT 1 retained.
You can use the back button provided by Power BI to return to DT 1 after drilling through to DT 2. hope your data model supports the relationship between the project filter on DT 1 and the detailed data on DT 2.
DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL (youtube.com)
Cross-report Drillthrough in Power BI (youtube.com)
- Kedar_Pande
--Set Up the Drillthrough for DT 2:
Go to DT 2 and add a field to the Drillthrough Filters section (like Project Name or Project ID). This will allow you to pass the project context from DT 1 to DT 2.
--On the DT 1 page, when a user right-clicks on the project detail visual, they will be able to select Drillthrough > DT 2.
This will take them to DT 2, with the same project context passed along.--You can add a "Back" button to DT 2 to let users navigate back to DT 1 by using the Insert > Button > Back option.