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

7311fd6c 01e3-4b96-8ec3-08054c7cad23 on 05 Jul 2020 22:17:49

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

It would be good to be able to promote a slicer to a report-level filter. I'd say the same for a cross-filter too.

Speaking for myself, the reason I like slicers over filters is because I often have filters that I don't want the end-user to interact with. For example I might filter out junk records. If there was a way to have "end-user" filters that were separated from design-view filters, I think this would help me use filters more. With a slicer I have much more control over what people see.

Tas Ranson's profile image Profile Picture

034519ac 4ff6-4157-bd15-2f889d260205 on 05 Jul 2020 22:17:49

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

Copying Kristin Pugi's comment below. This is how I'm building reports and users would much rather interact with slicers on one page and have them apply to all pages rather than using filter pane on selecting Report FIlters.

Must have feature. It would connect pages to reporting solution. Into first page you create overview page with key metrics and filters, you choose proper filters and see different pages filtered same. And not only Slicers - I would suggest making option to visual also act like global report level filter. Is it so hard to add property to the visual/slicer "Act as report level filter" :-)

Tas Ranson's profile image Profile Picture

c1866e5b 6cd5-457b-a911-59b495e9cd61 on 05 Jul 2020 22:17:46

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

It is critical to have this feature. Makes it difficult for user to navigate across tabs for analysis. Surprising that feature isn't supported currently.

Tas Ranson's profile image Profile Picture

940a375e b506-4d88-a0b6-45b7e4782698 on 05 Jul 2020 22:17:36

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

It is ridiculous that this feature is not implemented in Power BI

Tas Ranson's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:17:23

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

This is extremely important and I am surprised that this is not implemented in Power BI, since it exists in PowerView (and Excel).

I want to design my reports so the first page is where the user sets all the slicers as parameters, which are applied to all visuals as users move through the other pages of the report.

Basically when editing the interactions of a slicer, we should be able to set these across pages.

Tas Ranson's profile image Profile Picture

187edd25 42cb-48dd-a8a2-b33694e3d02b on 05 Jul 2020 22:17:21

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

It is difficult to have guided analysis without this functionality. We have a number of customers asking about his feature - Global Filters just doesn't cut it.

Tas Ranson's profile image Profile Picture

4e2ed990 e62a-4956-94cf-e2ae7078a9e9 on 05 Jul 2020 22:17:19

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

This is required to be able to set up reports for end users that are flexible

Tas Ranson's profile image Profile Picture

23e0d895 df42-49c5-94e2-b26669c3be1d on 05 Jul 2020 22:17:10

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

I'm really surprised this doesnt already exist. Huge functionality loss.

Tas Ranson's profile image Profile Picture

0b7d39db 1085-4dc3-bc4d-4a5a9b4ec67f on 05 Jul 2020 22:17:03

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

This would be a great add!!!!!

Tas Ranson's profile image Profile Picture

63006d54 e841-4eaa-aae2-c3f93bb2a5e0 on 05 Jul 2020 22:17:01

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

This should also apply to the visualizations.
If I click on a visualization and it applies a filter, that filter should apply across pages.
(We'd also need some kind of button to clear all slicer/viszualization filters)