Forum Discussion

anabianco09's avatar
anabianco09
Icon for Helper II rankHelper II
2 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    2 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

    • anabianco09's avatar
      anabianco09
      Icon for Helper II rankHelper 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?

      • Anonymous's avatar
        Anonymous
        Not 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!