Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AnetaK
Helper V
Helper V

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. 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super 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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super 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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not 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. 

 

Untitled.png

In 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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



stretcharm
Memorable Member
Memorable 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.

https://powerbi.microsoft.com/en-us/blog/congratulations-to-the-winners-of-the-bookmarking-feature-c...

 

 

The drillthrough function seems to be quite useful. Thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.