Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 I need the data table to change dynamically based on the graph on the first page.
Solved! Go to Solution.
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.
You can sync a slicer and use it on any or all pages in a report.
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.
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? @ebeery