Forum Discussion
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!
3 Replies
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.
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.
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.
