Forum Discussion
Solved
Filter data table based on bar graph selection
I have a report that has a graph and when one of the bars is selected I want it to filter the data table so that only that data is shown. But the data table and the graph are on different pages. So ...
If you add the category from your bar chart as a drillthrough field on your data table page then users would be able to right-click on the elements of the bar chart and use drillthrough to go to the data page, which would be filtered by the category they chose.
poweruser55 this approach isn't making a whole lot of sense to me. To my knowledge, it is not possible to change data on another page with a selection from a bar graph.
Instead, I would recommend using slicers on each page, synced together using the "Sync slicers" options.
When I click on the blue bar in the first picture then I press the arrow button it takes me to a data table. How would I use sync slicers for this? Anonymous