Filtering by clicking on a visual and maintain across pages

[gianmarco]

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

[speedramps · Accepted solution]

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]

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]

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.

[gianmarco]

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

[Fsciencetech]

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

@marcorusso , Please suggest if you have custom idea.

[gianmarco]

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