Is there a way for the end user to have drill down capabilities after providing a published link to them? For instance on this pie graph and set of filters that are related:
End users can of course very easily pick one of the category types and the pie graph will update to show how many cases via phone/email are of that category type. However, I've been asked if there is a way to click the pie chart itself and get some kind of drilldown view that will show the same thing? I'm not sure if that's possible and from what I've seen the users aren't given much flexibility to drilldown further other than doing this:
This only gives you a full screen view of the chart itself and not a break down of the data behind it. The only thing I can think to do is change the visualization to something like a matrix which I don't think they want. I'm basically being asked to replicate how Salesforce does their reporting which is where this data comes from. You can view a dashboard, click on any dashboard component and be taken to a report view of the component that contains data seen and not seen on a chart (this is an unrelated example by the way):
From here, you can click on the donut chart to go to this view:
Is there a way to do something like this in PBI?
Refer the above link.
It has interactive drilldown and auto grouping features.