Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |