Forum Discussion

DeBIe's avatar
DeBIe
Icon for Post Partisan rankPost Partisan
3 years ago

How to disable drill-through?

Hey all,

 

I'm using my lookup value (for example: Supermarkets) as a drill-through field on one page. On my second page I am using the same lookup value, but with others information which is not suitable for the drill-through functionality. However, it's still possible to right-click the visual on the second page and select drill-through. How can I turn this of for this visual?

 

Thanks!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi DeBIe ,

     

    You mean you want to drill through only the relevant information pages, right?

    Please try to set the drill-through destination conditionally.

    Or you can create a duplicate of the drillthrough target column, and then use that on the pages where you don't want the drillthrough to fire.

     

    Please refer to the following posts for more information.

    Solved: Disable drillthrough for few visuals - Microsoft Power BI Community

    Disable Interactive/Drillthrough in Power BI Report | Power BI Exchange (pbiusergroup.com)

    Controlling drill-through to specific visuals - Microsoft Power BI Community

    Disable right click option - Microsoft Power BI Community

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution to help the other members find it more quickly. 

    • DeBIe's avatar
      DeBIe
      Icon for Post Partisan rankPost Partisan
      3 years ago

      Hey Anonymous ,

       

      Thanks for replying.


      "You mean you want to drill through only the relevant information pages, right?"
      No, there is only one page available for the drill-through. What I want is to disable the drill-through functionality on another page, because i'm using the drill-through column there as well).

       

      "Or you can create a duplicate of the drillthrough target column, and then use that on the pages where you don't want the drillthrough to fire."

      Thanks for the suggest solution. However, it really sounds like a messy way to solve this. It will also give me a lot of more redundant data. I would like to keep my model optimized.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi DeBIe ,

         

        Unfortunately, due to the design, your needs cannot be realized, you can post your idea to Ideas .

        https://ideas.powerbi.com/ideas/

         

        The only way is to create a duplicate of the drillthrough target column, and then use that on the pages where you don't want the drillthrough to fire.

         

        Best Regards,

        Neeko Tang

        If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly.