Bar chart drill-by should subset data

[anbitrifork]

Today, when you click drill-by on a bar chart, the chart changes dimension to the new selected dimension, but data is not filtered in relation to the bar, you clicked.

User story:
I have a bar chart showing 10 bars, one for each country. I click on bar for 'Germany' and choose drill-by city.
I expect to see a bar chart of German cities, but instead I get a bar chart of all cities in the data set (cities from all 10 countries).

It would be more intuitive to have the data set filtered respectively to the bar, that you clicked. In fact, the pie chart works exactly this way.

[rusackas]

Circling back on this one. Jay took a swing at it in #36901, and the discussion there landed on @michael-s-molina's suggestion: rather than special-casing the bar chart, let the user pick what to consider when drilling (the clicked bar's x value, the series value, or both), same pattern as Drill to detail by. I've adopted the feature in #42296 with that approach, so drilling into the Germany bar by city gets you just German cities. Thanks for raising this!

[anbitrifork]

Thank you Evan. Can't wait to try it out :-)