Drill through using slicer or navigate page keeping filter

[Christianvs]

Hi

I got the following table

and the following pages

On the navigation page I have a slicer containing the ID's and a button for going to another page

I wish to be able to select an ID in the slicer and then go to the page linked to that ID in the table and keep the selected ID as filter. 

If I set the action of the button to conditional page navigation I can make it go to the appropiate page, but the filtered ID isn't kept.

On the other hand, if I set the action of the button to conditional drill through I get the following message due to the fact that I have only filtered the table and doesn't have a selected data point.

Is it possible to either select the data point that is chosen in the slicer so I can use drill through or keep the filter from the slicer when using page navigation?

I would prefer to get the drill through function working

Thanks

[YukiK · Accepted solution]

There is a feature called "sync filters". Go to the views pane and you can select your slicer as a sync filter that's synced across report pages. Hope that makes sense!

[Christianvs]

Thanks YukiK 🙂

It made perfect sense and does the job!