Drill Through Only If All Fields are filtered on parent page

[RandyPgh]

Is it possible to ensure that the user drills through to a detail page only if ALL of the drill through filter fields are in the parent visual/page? For example, if I have a drill through page that has both store name and product number in the drill through filters, the user can drill from a visual on a parent page that has only store name categories. I would like to prevent that action because the drill through page needs both. 

I am aware of conditional drill through using buttons, but there are two problems with that solution. First, this takes valuable real estate on the pages. Second, the user can always right-click any visual and choose the drill through option, circumventing my button.

[RandyPgh · Accepted solution]

The result was that I created the conditional drill through buttons. Since the users can still drill through using the right-click, it will simply have to be user training that focuses them on button usage.

[v-yingjl]

Hi @RandyPgh ,

When you have both store name and product number in the drill through filters, you can drillthrough to this page from the parent page which stores visuals including product number or store name field, just make the drillthrough page visuals have both fields to get the details.

Plesae refer: Set up drill through in Power BI reports 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@RandyPgh yes, not both the columns required for drill thru, in this case, if there is only store name, users can drill thru from that visual using store name.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡