Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Solved! Go to Solution.
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
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
@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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.