Forum Discussion
Filters on multiple pages
Hello,
Is it possible to create a filter/slicer/whatever on page 1 that would filter also page 2 or 3?
For example on the home page of the report I select a country and then I can move to other pages and I see data only of that one selected country.
I know that there is a "report level filter" on the visualisations pane but I need something "inside" the report.
On the home page there is a table with countries so it would pe perfect if that filter could be somehow bound with this table.
Hi AnetaK,
The February update came with this feature so now you can sync slicers on multiple pages check the links below:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/
https://docs.microsoft.com/en-us/power-bi/desktop-slicers
Regards,
MFelix
5 Replies
- MFelixSuper User
Hi AnetaK,
The February update came with this feature so now you can sync slicers on multiple pages check the links below:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/
https://docs.microsoft.com/en-us/power-bi/desktop-slicers
Regards,
MFelix
- AnonymousNot applicable
Hi,
With this feature It is just adding Slicer on New page also.
What If I want to keep Slicer only one page 1 and then based on page 1 slice selection data should be filter on page- 2 also.?
I tried using Selection and Sync Slicers Properties and looks like it is working.
- MFelixSuper UserIn this case you must select the option to sync slicers and on page 2 hide the slicer that way you will have the slicer on page 2 but no visible for users.
Regards
MFelix
- stretcharmMemorable Member
Slicer type filters that apply on all pages is one of the most requested new features so it will hopefully be added soon.
For now you can do drill throughs that can switch to other pages with a
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
You can also set up a single page and use bookmarks/selections to Show/Hide different items that you may have put on different pages
https://www.youtube.com/watch?v=_Afcj8mT5_Q
The bookmark contest winner shows the sort of things that can be done.
- KeithChuHelper I
The drillthrough function seems to be quite useful. Thanks!