Skip to main content

Power BI

Completed

Allows Slicers to apply to all Pages of a Report

Vote (4675) Share
Tas Ranson's profile image

Tas Ranson on 22 Sep 2015 07:58:16

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.

Administrator on 07 Feb 2018 08:04:38

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.

Comments (512)
Tas Ranson's profile image Profile Picture

8a02dfe7 95a3-4f57-91d9-867b6577b88b on 05 Jul 2020 23:15:26

RE: Allows Slicers to apply to all Pages of a Report

Incomplete. Needs to work the same way as setup in the report, in the dashboard. for example if i pin the two live pages from the report to a dashboard they should remain synced

Tas Ranson's profile image Profile Picture

3e2c68aa 4c58-4b73-a749-7e0a40c2923a on 05 Jul 2020 23:15:16

RE: Allows Slicers to apply to all Pages of a Report

It doesn't work when you view this in the Dashboard view and pin the different pages.

Tas Ranson's profile image Profile Picture

f39e5539 8320-415e-aafa-8542396d3e71 on 05 Jul 2020 23:14:30

RE: Allows Slicers to apply to all Pages of a Report

Hi, totally agree with previous comments that this release doesn't quite fulfill the request. Syncing slicers means we have to include the slicer on every page of a report, when the idea is to have the user make their selection only once in, for example, the first page.

Tas Ranson's profile image Profile Picture

c1b63b17 ae5a-4f4b-a184-bda304fe851b on 05 Jul 2020 23:12:52

RE: Allows Slicers to apply to all Pages of a Report

Great, this really helps but would be much better if ithere was an option to set it to only work one way or both ways between synced pages.

If I set a slicer to sync other pages, and several of those pages already contains a slicer with the same field, slicing on any of those pages wil sync all slicers across those pages as well.This really limits how this can be used.

For example; Id like a page with some global slicers connected to all pages that users can set as a starting point; if they chose to. But on individual pages still be able to slice and dig down to granular "page specific" levels without syncing all those other pages that contain a similar slicer.

Tas Ranson's profile image Profile Picture

46891db3 1c35-48e4-b0ef-f53bc5c427f0 on 05 Jul 2020 23:12:43

RE: Allows Slicers to apply to all Pages of a Report

Yes please add

Tas Ranson's profile image Profile Picture

a8089ae0 3d90-4f17-b896-f090657ea538 on 05 Jul 2020 23:12:31

RE: Allows Slicers to apply to all Pages of a Report

I think this is still incomplete as it doesn'twork well on the cloud version. It doesn't work when you view tis in the Dashboard view and pin the different pages. Also it seems like a make shift solution as the idea was to have one slicer that could act as a single command for different pages, instead it's syncing other slicers in these pages...yeah I can hide the slicers in the pages using selection pane but still it's imperfect. I haven't tried publishing the report as yet so can't speak on that front. Please don't close this as there's still lots of improvements required to this feature.

Tas Ranson's profile image Profile Picture

df3952a2 3e17-42e4-84ef-a0bb9e94aaf2 on 05 Jul 2020 23:12:31

RE: Allows Slicers to apply to all Pages of a Report

A report level slicer is really a must !!!!

Tas Ranson's profile image Profile Picture

41b3c6a0 e41c-e811-813a-e0071b6ad011 on 05 Jul 2020 23:12:23

RE: Allows Slicers to apply to all Pages of a Report

This does not work! I have 3 slicers on a page, all default slicers and NO custom slicers. This will NOT work on more than two slicers.

Pure Garbage!

Tas Ranson's profile image Profile Picture

d3584cc4 03a4-4315-a8f2-111d1bf02c72 on 05 Jul 2020 23:12:22

RE: Allows Slicers to apply to all Pages of a Report

Excellent feature, a huge thanks to the the BI team for developing this. It will be a big help for my client dashboards

Tas Ranson's profile image Profile Picture

034519ac 4ff6-4157-bd15-2f889d260205 on 05 Jul 2020 23:11:41

RE: Allows Slicers to apply to all Pages of a Report

Thank you for this enhancement as it was sorely needed, but like others have mentioned below, I use the custom hierarchy slicer so users can easily break down to see who reports to who and filter. A bit disappointing to see that this functionality is only for built in slicers. I haven't really seen Microsoft re-work a closed ticket and considering this is 2.5 years old with so many comments, I opened another here for all those who need this functionality to expand to custom visuals.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33254524--apply-slicers-to-all-pages-of-a-report-needs-to