Forum Discussion
Dynamic Drill Through?
Hi jrichview
You may have a look at below articles about drill through. It seems impossible to do that but maybe i misunderstand it. So it's better you could share some data which could reproduce your scenario and your desired output.
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Regards,
Cherie
Yes, I've read all this and it revolves around a pre-defined drill-through. What we need is to permit the end user to choose from a list which type of drill through they want.
Our report is published to web and hosted in an iframe so we're not talking about a user with a Power BI license.
I'm wondering if it's possible to create a custom PBI control that would present a dropdown list and modify the appropriate drill fields on the associated table so that when the user clicks a row it drills through the way they requested.
- v-cherch-msft7 years ago
Microsoft Employee
Hi jrichview
It seems you may try to use HierarchySlicer. Here is the sample report for your reference.
Regards,
Cherie
- jrichview7 years ago
Helper I
Although that does look like a useful slicer in general, it's unclear how that would enable my use case.