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):
Is there a way to do something like this in PBI?
Helpful resources
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
