cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gianmarco
Helper III
Helper III

Filtering by clicking on a visual and maintain across pages

Dear All,

I'd like to click on a visual (i.e. a row on a table) and by doing so activate the filter. The thing is: The filter works for the other visuals on the same page, but when I change page I lose the filter. 

Any idea on how to maintain the filter across pages by clicking on a visual?

Thanks so much

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

Hi again gianmarco 

 

As I mentioned above,

 

You can create a slicer, then on the top menu click view, sync slicers and use the tick boxes to sync the slicers on the other pages. When you select a slicer on one page it will then also apply to the specified pages. 

see https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

 

Alternatively, you could create a drillthrough. So when a user clicks on a selection in a visual they can drillthough to another page based just on that selection.

see https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough 
 

When you click on a visual, it filters the other visuals in the same page only. It will not filter the visuals in the other pages. That is when you need to use sync slicers or drillthroughs. I sounds like drillthroughs will be ideal for you requirements.

 
Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !

View solution in original post

6 REPLIES 6
speedramps
Super User
Super User

Hi again gianmarco 

 

As I mentioned above,

 

You can create a slicer, then on the top menu click view, sync slicers and use the tick boxes to sync the slicers on the other pages. When you select a slicer on one page it will then also apply to the specified pages. 

see https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

 

Alternatively, you could create a drillthrough. So when a user clicks on a selection in a visual they can drillthough to another page based just on that selection.

see https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough 
 

When you click on a visual, it filters the other visuals in the same page only. It will not filter the visuals in the other pages. That is when you need to use sync slicers or drillthroughs. I sounds like drillthroughs will be ideal for you requirements.

 
Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !

speedramps
Super User
Super User

You can create a slicer, then on the top menu click view, sync slicers and use the tick boxes to sync the slicers on the other pages. When you select a slicer on one page it will then also apply to the specified pages. 

see https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

 

Alternatively, you could create a drillthrough. So when a user clicks on a selection in a visual they can drillthough to another page based just on that selection.

see https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough 
 


Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !

Fsciencetech
Helper III
Helper III

As I understand - You are clicking any visual and activate the filter(Slicer). and other visuals filters on the same page.

 

if you are using slicer then you make sync the slicer and get the filter on other pages.

Fsciencetech_0-1635153454373.png

 

Dear @Fsciencetech 

I already activated the synchronization between filters in different pages. In fact, when I make a selection using the filter, it remains selected in other pages.
My problem, on the contrary, is: when I click on a visual, it filters the other visuals in the same page only. But I want the click on a visual to also filter the visuals in the other pages...

I can understand your requirement, but this functionaly is not available in Power BI yet.

@marcorusso , Please suggest if you have custom idea.

Dear @Fsciencetech 

I think I can manage this by means of Drill-throughs. 
But it would be amazing if you could activate filters (slicers) with only a click on a visual...

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors