Allows Slicers to apply to all Pages of a Report
As has been partly implemented with Filters, it would be very useful to have slicers that could apply to all pages of a report. This would allow users to interact more easily.
The most exciting news so far this year! In the February release of Power BI Desktop we’ve shipped the ability to synchronize slicers on different pages in your report! You can read more about how the feature works here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/#syncSlicers
Thanks again for everyone’s feedback and votes on this feature. We do listen to you so keep voting and let us know what other things you need us to prioritize.
Looks like this broke the ability to have a slicer sort by a second column as per this thread
I've updated my version and refreshed a report that previously sorted a date slicer using a secondary sort column - it doens't work anymore and is sorted alphabetically.
Linda Kammerer commented
Will things like the hierarchy slicer be able to take advantage of this? Didn't seem to work for me. Since they are vetted in the Microsoft Store, they should be able to take advantage of this option.
John Heesterbeek commented
Great functionality, only issue is the filters are not taken into account with the Export to PowerPoint. Is this an open action?
Volker Heck commented
Thanks - navigating multiple pages meets the end user's expectations now!
We are expecting same functionality for chicletslicer.
Thanks Will and team much appreciated!
Tobias Ljung commented
Thank you team
Harry Leboeuf commented
Great, but so pity it only works on the standard slicer. Still missing Hierarchies ! (The Custom Visual works fine, but is not synced) ... :-(
Power BI team, thanks for this but it can't be considered as completed as the request was "slicers that could apply to all pages of a report". This is not just a sync between slicers on different pages, but a single slicer that could apply to all other pages. E.g. one could create a page only with slicers and place reports on other pages. Sometimes slicers take too much space on a sheet!
Hugh Cox commented
'Completed' is a little optimistic. Not all objects that are available work in this way, previous iterations of the dashboards do not inherit this functionality, there are is no 'Current Selection' object or bread crumb notification.
So well done on delivering a fundamental must have for any visualisation tool nearly 2.5 years after it was initially requested.
Still some work to go before you park this one.
Igor George Abdo commented
Congratulations Team PowerBI.
Does this work for custom slicers? Seems to work only for built in slicers!
Gabriel Grünberg commented
How is this still not done? Starting to be annoying having to apologize that you have to "re-select" the entity you want information for on every page when this is base feature in every other visualization tool.
So good that this feature is finally coming !
@Jon - @erin 's instructions worked for me.
Amir Netz commented
For all of you desperate for an update:
The feature is now showing in the Power BI Service and will be shipping next week as part of the Power BI Desktop update for February.
I believe that was a leak or something, because that is definitely not there now if you "edit report" and select "view".
I've just found this - go to "edit report" in one of your reports in your Power BI service publishing space. Once there - select view and you should have a "Sync Slicers Pane" on/off toggle.
Turn it on and then you can choose which slicers you want to sync on which pages of the report