Skip to main content
Microsoft Idea

Power BI

New

Automatic Drill Down when filtered by slicer (Clustered bar chart)

Vote (21) Share
Ellie Wierzgacz's profile image

Ellie Wierzgacz on 20 Aug 2021 15:31:12

Is there a way to add a feature that would allow automatic drill down in a visual, specifically the clustered bar chart, so that when using a hierarchy view, whatever is selected in the filter/slicer is automatically drilled down to the appropriate hierarchy? 



For example, I have a team hierarchy (sector, segment, region, area, team) and I'd like the bar chart to automatically drill down to the next level of hierarchy (if an area is selected, then all teams within that area will automatically come up in the visual).