Forum Discussion
Dynamically update stacked bar chart data based on selected user in a slicer
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?
- 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.
1 Reply
- 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.