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

d5c46788 0541-425c-907d-a096a02fa483 on 05 Jul 2020 23:59:23

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

Dan Green is right, we have to copy and paste all filters on each page. After that I resize them to the minimum to hide them to the user. I think a check in the initial filter is better.

Tas Ranson's profile image Profile Picture

a5db5d9b 5fed-48e7-8a3c-ca7ef655f466 on 05 Jul 2020 23:57:53

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

This requires the same slicer on each page. It would be better if a slicer on page one can affect visuals on other pages without needed to have the same slicer.

Tas Ranson's profile image Profile Picture

3e6c3a3c 9e63-4332-8017-ad43a449cac2 on 05 Jul 2020 23:40:21

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

Would be good to have this functionality (as a tick in the slider properties)

Tas Ranson's profile image Profile Picture

90a96ff0 e975-40c2-9e31-4578d75c741b on 05 Jul 2020 23:36:42

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

Further work needed

Thanks for the basic slicer, however I needed to be able to show a list of all Project Managers on one page, the selected PM being used to show their project details on subsequent pages. Unfortunately, due to the luxury of having several PMs, the list goes over one screen, unless I shrink the font and supply a magnifying glass.

Someone suggested using the ChicletSlicer (1.6.0) which allows you to split the list into columns across the visualisation, thereby making it readable.

The only drawback, Sync slicer doesn't recognise it as a slicer so won't pick up the selection

Please can this solution be extended to all slicers.

Tas Ranson's profile image Profile Picture

3141a8b4 d1f8-40fb-b6f6-82c966c0732d on 05 Jul 2020 23:30:19

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

Hi ,
What is the plan to include multi cell drill through reporting in Power BI ? Oracle is claiming to include this in OAC ....any thoughts ?

Tas Ranson's profile image Profile Picture

737b48f6 6b49-49c5-ad0d-348965e7af9a on 05 Jul 2020 23:27:29

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

Hi, thanks for the explaination!
How to bring the slicer working for the app "HirarchySlicer"?
It just works for the app "data slicer"....
PLEASE HELP!

Tas Ranson's profile image Profile Picture

d0270846 5691-48a0-b295-8d39ce5f6958 on 05 Jul 2020 23:22:47

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

Sorry i'm not agree. It's NOT completed, until a single slicer in a single place apply to all pages this idea will not be completed.

Tas Ranson's profile image Profile Picture

e0742248 546f-43c2-b63c-52f81e62ddda on 05 Jul 2020 23:18:19

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

Definitely need a report level slicer

Tas Ranson's profile image Profile Picture

776d573d 253c-e811-a95c-000d3a1bee29 on 05 Jul 2020 23:16:41

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

'+1

Tas Ranson's profile image Profile Picture

eb5b25fa 312f-43bb-9d94-785f0939caf9 on 05 Jul 2020 23:15:59

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

Definitely need a report level slicer