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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

How to make interactive filter in power bi between 2 pages (not slicer)

I have a case where I have to make interactive filtering on few sheets.

 

Explanation: 

suppose page 1 and 2 have part_nbr field in filter pane and both of the pages have matrix visual in it.
i want to make the interaction between this filter of both pages such that if I choose part_nbr as 1234 in page 1 then page 2 also show the visuals (matix) for part_nbr 1234 and I don't want to show slicer for part_nbr on either of the sheets.

I can't use filter on all pages as well as I want this interactive filter on 2 sheets only in a 10 page report

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Based on your description, the filter cannot meet your requirements.


There are three levels of filters in Power BI: report, page, and visual.

Report-level filters are those that affect all of the data in the report, regardless of what you're looking at. Think of them as universal filters.

Page-level filters only filter the data on a given page, which makes them useful for creating pages that focus on particular subsets of your data. For example, you can use page-level filters to make one page focus solely on revenue data, while the next page focuses on expense data. Page-level filters operate within the context of the report-level filters, which means that a page-level filter cannot override a report-level filter. They also cannot be programmed to filter the data on other pages.

Visual-level filters only filter the data on a given visual, whether that's a table, chart, card, slicer, etc. These are the most granular filters you can apply to your data, and they operate within the context of both the page-level and report-level filters, which means visual-level filters cannot override them, nor can they be programmed to filter data on other visuals.



Please try the synchronize slicers

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Based on your description, the filter cannot meet your requirements.


There are three levels of filters in Power BI: report, page, and visual.

Report-level filters are those that affect all of the data in the report, regardless of what you're looking at. Think of them as universal filters.

Page-level filters only filter the data on a given page, which makes them useful for creating pages that focus on particular subsets of your data. For example, you can use page-level filters to make one page focus solely on revenue data, while the next page focuses on expense data. Page-level filters operate within the context of the report-level filters, which means that a page-level filter cannot override a report-level filter. They also cannot be programmed to filter the data on other pages.

Visual-level filters only filter the data on a given visual, whether that's a table, chart, card, slicer, etc. These are the most granular filters you can apply to your data, and they operate within the context of both the page-level and report-level filters, which means visual-level filters cannot override them, nor can they be programmed to filter data on other visuals.



Please try the synchronize slicers

amitchandak
Super User
Super User

@Anonymous , The possible ways are report level filter (filter - All pages) in filter pane.

 

Sync slicers - when you use the slicers

 

Or allow drill through

 

First to are beest option to sync filter

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

I can't use filter on all pages as well as I want this interactive filter on 2 sheets only in a 10 page report

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors