Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RRaj_293
Helper III
Helper III

Drillthrough only for selected values within a Column

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 ReasonOrders
No Stock890
Cancelled289
Sales193
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors