cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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
Super User III
Super User III

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
Super User III
Super User III

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

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





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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors