Martin Larsson on 17 Aug 2018 18:28:57
When showing hierarchical data in a column chart and drill down is enabled I would need the above level in the hierarchy to stay in the chart as comparison to the lower level data.
So when the user has gone down one level the selected top level bar is showing to the left in the chart. When clicking further the intermediate levels are places to the left of the current level.
It would also be useful with breadcrumbs but that is a separate idea (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11697054-drill-down-functionality).
See my illustration in the link below.
https://preview.ibb.co/nGXGiK/Power_BI_hierachical_data_in_chart.png