Forum Discussion

TharukaNG's avatar
TharukaNG
Frequent Visitor
1 year ago
Solved

Drill through is not visible

Hi,

When I right-click on a visual drill-through option is not available. Am I missing any configuration?

I have also enabled the 'Cross-report Drillthrough' option in the Report settings. 

 

 

 

 

  • TharukaNG 

     

    If you want to enable "Drill Through" to a different page on the same report then you dont need to enable "Cross report drill through". First create a drill through page categorize a page as drill through page, and add the Fields into the drill through well, on top of which you want to enable Drill through and then when you hover over a visual which is having those fiels will show that option "Drill Through"

     

    I belive since you enable on-object feature in your power bi desktop you are not able to see drill through config options in format menu, now is it changed

     

    check out this 3 min video, I guess you will find the solution for your issue

     

    https://www.youtube.com/watch?v=eYxRHJ0hB_E

     

    Need a Power BI Consultation? Hire me on Upwork

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!


5 Replies

  • TharukaNG 

     

    If you want to enable "Drill Through" to a different page on the same report then you dont need to enable "Cross report drill through". First create a drill through page categorize a page as drill through page, and add the Fields into the drill through well, on top of which you want to enable Drill through and then when you hover over a visual which is having those fiels will show that option "Drill Through"

     

    I belive since you enable on-object feature in your power bi desktop you are not able to see drill through config options in format menu, now is it changed

     

    check out this 3 min video, I guess you will find the solution for your issue

     

    https://www.youtube.com/watch?v=eYxRHJ0hB_E

     

    Need a Power BI Consultation? Hire me on Upwork

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!


  • Anonymous's avatar
    Anonymous
    Not applicable

     

    Thanks for the reply from tharunkumarRTK , please allow me to provide another insight:

    Hi, TharukaNG 
    Thanks for reaching out to the Microsoft fabric community forum.

    Could you please let us know if  tharunkumarRTK‘s response resolved your issue? If it did, kindly accept it as the solution.

    Indeed, as tharunkumarRTK mentioned, when you want to use the Power BI cross-report drillthrough feature, you need to set up a drillthrough target page. Below is a screenshot from the relevant documentation:

    Additionally, if you are using the service, you need to enable the following switch:

    For more details, please refer to the documentation:

    Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn

    Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

     
    Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
     

    Best Regards,

    Leroy Lu

    • TharukaNG's avatar
      TharukaNG
      Frequent Visitor

      Thank you for the comprehensive answer Anonymous. Good to know that it needs to be enabled in the PowerBI service as well.  

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi, TharukaNG 
         

        I'm delighted to hear that your issue has been resolved, and thank you for sharing your experience with us.

         

        It has been my pleasure to assist you. If you encounter any further issues in the future, please feel free to return to the forum with your questions.

         

        Wishing you all the best!

         

        Best Regards,

        Leroy Lu