Forum Discussion

DeBIe's avatar
DeBIe
Post 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 s...
Need Help
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
    Post 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.