Dynamically update stacked bar chart data based on selected user in a slicer

[sunit1190]

I have a Leader Hierarchy set up as Y-Axis & a slicer for leaders at the top of the page and I want to filter the stacked bar chart Y-axis for the leader selected in the slicer. My issue is that currently the Y axis resets to the top of the tree leader and I have to manually drill down in the chart to the leader selected in the slicer. How can I get  the Y-axis of the stacked bar chart to only show data for the selected leader in my slicer without having to drill down? 

 

[lbendlin · Accepted solution]

- Don't use a hierarchy

- Use a disconnected table with all users in a flat list. Use that to feed your slicer

- Use measures to filter the stacked column chart visual.