Forum Discussion
Drill through target report
Hi all, I have a dashboard set up with a drill through option and when I click on a category on my source report page and click on Drill through, it shows up two options (two report pages).
How can I delete one option, as one wouldn't show the correct information?
In this case the DT_WIP would not give the correct results.
- Anonymous2 years ago
Hi anabianco09
As these target pages are all needed in your report, you may try a workaround to create a copy of the field that you don't want to drillthrough by, and use the copy field in the visual to replace the original field which is a drill-through field on another target page.
Solved: Disable drillthrough for few visuals - Microsoft Fabric Community
Another workaround is to use the Drillthrough buttons. With the visible buttons, you can direct people to the specific pages they are set for. Create a button for this visual and create another button for another visual.
Create a drillthrough button in Power BI - Power BI | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
3 Replies
- PijushRoy
Community Champion
Hi anabianco09
Please remove the Drill through option for DT_WIP page- anabianco09
Helper II
Hi! On here?
I did and it still shows up as an option... However there is something else, this DT_WIP page would show the right result from another visual on the source page.... Is it still possible?
- AnonymousNot applicable
Hi anabianco09
As these target pages are all needed in your report, you may try a workaround to create a copy of the field that you don't want to drillthrough by, and use the copy field in the visual to replace the original field which is a drill-through field on another target page.
Solved: Disable drillthrough for few visuals - Microsoft Fabric Community
Another workaround is to use the Drillthrough buttons. With the visible buttons, you can direct people to the specific pages they are set for. Create a button for this visual and create another button for another visual.
Create a drillthrough button in Power BI - Power BI | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!