Forum Discussion
Filter Automatically Across Multiple Pages in Power BI
I have a Power BI report with 9 pages. On the first page, I've implemented a drill-through functionality that takes me to the second page when I choose a specific row from a table. For example, if I select drill-through on the first page for the row where ID is 10, I correctly see only the data related for ID 10 on the second page.
Now, I want this same filter (for ID 10) to be automatically applied to the third page and all subsequent pages. I want to see only the rows related to ID 10 on these pages as well. However, I want to avoid using the "Sync Slicers" option, and I do not want to add drill-through functionality to the remaining pages. The drill-through from the first page should only show to the second page.
Is there a way to achieve this in Power BI? Thanks so much.
3 Replies
Hi tijanakljajic ,
Without having the sinc of slicers or the drill-trough you cannot pass the filters from page to page, you have the Filter pane however that is not getting the values from the drill trough being implement directly.
Hi MFelix ,I agree with your idea.
Hi tijanakljajic ,
Regarding your question, if you need to pass filtering across pages, it seems that you can only use synchronized slicers and drillthrough.
Best Regards,
Wenbin ZhouSame! I have a first page which has a list of all projects, and want the user to be able to drill through to details pages which provide additional information about the project. I don't want the user to have to navigate back to the first page to see a different view of information and equally don't want to have to create complex bookmarks.
