Skip to main content

Power BI

Completed

Apply the same filter across multiple pages

Vote (204) Share
Scott Ferguson's profile image

Scott Ferguson on 16 Mar 2017 22:11:37

I have a report that requires more than one page in the mobile view. The problem is both pages should reflect the same filters. I do not expect users to select the same filters again and again; the filters should be selected on the first page and apply to all subsequent pages.

This idea was previously posted under the heading "Make filters that can apply across all pages in a report". However, it will not longer accept votes as it is marked as completed. Is an option available to apply page level filters from the report/dashboard to subsequent pages?

Administrator on 06 Nov 2017 19:03:19

We are very happy to announce that filters are now available in phone reports. You can read about phone reports filters here - https://powerbi.microsoft.com/en-us/blog/filters-coming-for-phone-reports-on-ios/ Even though it doesn’t meet the specific ask for a report level slicer, page level reports offer the same functionality in an easy and friendly way. We hope you like this addition to the Power BI mobile apps and encourage you to experience it and provide us with feedbacks.

Comments (13)
Scott Ferguson's profile image Profile Picture

bb83f1e2 e200-4d21-af07-eba07d78b9ba on 05 Jul 2020 22:50:57

RE: Apply the same filter across multiple pages

This would be a huge help. Sometimes I want to create a table on another page with the list of records without re-filtering. Please add this!

Scott Ferguson's profile image Profile Picture

d6d3e97b b2eb-412a-812d-8c8a20f14acd on 05 Jul 2020 22:50:47

RE: Apply the same filter across multiple pages

Some analyses environments require more visualisations than one page can hold. I agree very much with this request. Or, alternatively, make it possible to scroll the canvas of the report when required (wasn't that one of the first advantages of windows 3.1 over MS-DOS 3.11?).

Scott Ferguson's profile image Profile Picture

9b7ce91d e830-4de1-ba37-766740b2a365 on 05 Jul 2020 22:49:54

RE: Apply the same filter across multiple pages

While building power pivot reports in Excel, if the report was expansive enough, I would create one sheet with just slicers that affected every pivot table and chart in the whole workbook. It really helped keep users in the same mind set by allowing them to choose parameters that apply to the questions they have at that moment and every visual lines up with that train of thought.