Drillthrough only for selected values within a Column/Field

[RRaj_293]

Hi , 

I have a drill down table as below which lists the Number of orders for each fail reason which is a drill down on Fail group.

Requirement - I want to be able to drill through to the details of the orders which make up to the count along with its related data . Example - for Drill through on 'No Stock' - I need to include in my detail page - order and Product related information. But for the drill through of other reasons listed product information is not relevant. 

So I need help and suggestions(or new approach) on couple of approaches I could think of -

1. Enable the drill function only on 'No Stock' and 'Cancelled' values of the fail reason.

OR

2. Be able to switch detail report /table within detail report based on the fail reason selected , so I can show product information for 'No stock' details page and other reasons would have only 'Order' related information in their respective pages.

Appreciate quick responses! Thanks in Advance.

Fail group
Fail Reason	Orders
No Stock	890
Cancelled	289
Sales	193

[v-shex-msft · Accepted solution]

Hi @RRaj_293,

AFAIK, the drill through filter only passes the confirfed table field filter effects from source to target page.(single direction)

I'd like to suggest you try to change some of slicer to sync mode If you want to achieve more filters directions or interactions through report pages. They can sync filter effects between different report pages.

Slicers in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng