Keep applied filters on page navigation action

[Michieldo]

Hi,

I have a page where I show all data for a specific company (filter on account table). For that company I want to show contract information that is presented in a different tab called contracts. In order to switch from the company tab to the contract tab I've included a button on the page that navigates to the contracts tab. However, I would to keep the filters that are applied (so let's say the selected company) whenever I click on the page navigation button so that on the contract tab only the contract information is shown of that specific customer. How do I do that?

P.s. Drill-through is not the preferred option here.

[Michieldo]

@BiNavPete , maybe you can also help me with a bit more complex situation on this same topic. What if we have both a synced slicer AND a drilldown measure on the page.

So it should work in the following way:
- If we drill through to this page from a different page; the filter should adjust based on the filter that were applied on the different page

So it should be synced but also sort of reset once you drill through so that filter applied from drilltrough and the ones selected are not in conflict.

Do you have a suggestion for this?

[BiNavPete]

Hi @Michieldo 

not quite sure I understand the question here. But just checked on of my PBIX's.
I don't sync slicers to the drill through page, because the drill through page will take whatever filters you've applied in the source page. MIght be that the drill through page needs more filters applied for it to work

Pete

[Michieldo]

Thank you for the quick reply @BiNavPete. I understand that my question is not very clear. Let me try with an example:
On the drill through page I have a slicer called company name with several statistics for the company selected. On the source page I have one of those statistics per company but you can drill down on the company to see all the statistics. I would like for the slicer on the drillthrough page to adjust based on the company I drill through from the source page. Currently all the measures on the drillthrough page move along with the drillthrough company from the source page, but the slicers doesn't.

[BiNavPete]

Sorry for not responding promptly. Been busy on other stuff.

Without a sample PBIX this is difficult for me to visualise

[BiNavPete · Accepted solution]

Hi @Michieldo 

The Sync Slicers pane will help you achieve what you're looking for.

Go to your Company tab, then click View | Sync Slicers.
Click on the Company Slicer and tick it on for the contracts page ( left hand tick boxes) in the sync slicers pane. If you want to see the slicer on the contracts page then tick the right hand box too.

Pete

[Michieldo]

Thanks you @BiNavPete , actually never seen this functioanlity but works like a charm!