Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Convenient cross-page filtering based on table search

Hi,

 

We have a cross page filtering problem.

We have 3 pages: Search page; Page A; Page B. On the "Search page" we choose a person from our table and we want to check him in detail on Page A or Page B. On the “Search page” we have a main table, which you can browse and choose a person. After choosing the person we don’t seem to find a solution to carry that information from the table itself, instead you have to search that person in a slicer in order to apply the filtering on the detailed Page A or Page B. 

 

We would like to find a workaround to make it more convenient and user friendly. Simply just a selection of one person from the “Search page” table and using that as a filter on Page A and Page B.

 

We tried drill-through, but in that case, you could only drill-through to Page A, and you have to go back to the “Search page” to drill-through to Page B, which is not convenient. It would be nice to drill-through to Page A and from that page navigate to Page B, while the chosen person remains the filter, but we did not find any solution for this kind of problem.

 

Thank you in advance,

Adam

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Please check if Sync Slicer can help

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages

https://powerpivotpro.com/2018/02/connect-one-slicer-power-bi-report-pages/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak 

Thank you for your answer!

We are currently using the Sync Slicer in order to filter Page A and Page B from the Search page. 
The problem is, that we do not want to use slicer. The goal is that after the user found the person that he/she wants to analyze in more details, the user selects it on the table and that selection filters Page A and Page B somehow and he/she should not have to search that name in a slicer too.

 

I hope, It was a clear describtion.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors