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.
Hi poweruser55 ,
Please have a try.
- With nothing selected on the report canvas, select the Slicer icon in the Visualizations pane to create a new slicer.
- With the new slicer selected, from the Fields pane, expand the District table and populate the slicer.
You can sync a slicer and use it on any or all pages in a report.
- In Power BI Desktop on the View ribbon, select Sync slicers.
- The Sync slicers pane appears between the Filters and Visualizations panes.
You can select the pages that the filter needs to synchronize.
More details: Sync and use slicers on other pages
Or you can filter the data on all pages and this cannot select the pages.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.