Keep filters when clicking button

[Irwin]

Hi guys,

I have made a report where you on the front page selects a distributor and this drillsthrough to the next page with distributor filter. I would like to create a button (arrow or whatever) that then takes you to a third page - easy. However, I cannot figure out how I tell PBI to keep the filters applied to the second page through the drill.

Is there some measure that I can use as a drill-through?

Thank you for your help 🙂

[amitchandak · Accepted solution]

@Irwin , if you have kept all these in add drill through the filter on thrid page(on thrid page) they should pass

[Irwin]

I tried that.
I added the same drillthrough filter to the 3. page (as on the second page). When I click the button it just "forgets" the filter.
I will try to publish the report and try through the published report instead of just through the app and see if that changes anything.

Thank you for your answer.

[amitchandak]

@Irwin , I need to check. Can you have a slicer for the distributor on the second and third pages and keep them in sync

[Irwin]

Hi,

I added a slicer for distributor on both 2. and 3. page. Said yes to keep them in sync. 

It is still the same issue. When I click the button (arrow) it take me to the third page but resets the distributor filter.

[amitchandak]

@Irwin , check the file attached  after signature 

Drill page 4 -> duplicate of page 4-> duplicate of duplicate of page 4

[Irwin]

Okay. I think I fixed it.
It was because the first selection was from a table (and a button with changing text). This would take me to page 2. Then from page two I wanted to keep filters with a new button.
I have now tried to use a slicer on page 1 instead of a table. This seems to fix the issue.
Thank you very much.