How to drill through from a stacked bar chart?

[ajitsahoo8338]

Hello Everyone, I need help with this.

I have a stacked bar chart in my visual, with the project name on the Y-axis, sales on the X-axis, and regions in the legend. I want to enable drill-through from the project name. Currently, I can only drill through from individual sales. I would like to be able to select any project and drill through to my next page.

Thank You,

Ajit

[Ritaf1983]

Hi @ajitsahoo8338 

Drill-through in Power BI works by navigating to a page that is filtered based on the specific data point from which the drill-through was initiated. In the case of a stacked bar chart, each segment in the stack is essentially treated as an individual column in the background. This is why you are currently only able to drill through from individual sales rather than the entire project name.

To work around this limitation, you can use an "override drill-through" approach.
The link to the override filters guide:
https://www.youtube.com/watch?v=BG51W2lKYIA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly