Filter a page from a table

[agusti_oliveres]

Hi all,

I am having trouble with the following problem: I would like to filter a page by clicking on the corresponding field from a table in a different page. It would basically be the same as the drillthrough filter, but without having to do the right click. Is it possible?

Thank you all in advance.

[v-danhe-msft · Accepted solution]

Hi @agusti_oliveres,

It’s not able to click on the value in a table visual to filter visuals data in another report pages without using drill through feature.

Based on your scenario, you can use the sync slicers function as suggested by RMDNA and refer to steps below.

1.I create two visuals in different pages. In page1 I create a Table visual and in page2 I create a Clustered column chart.

2.

2.I create a Slicer visual and add the [Product] field. Use the “sync slicers” function and check the “page1”, “page2”.

Now you can filter your data by the sync slicer.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/a9zeou1qghn5b4q/Filter%20a%20page%20from%20a%20table.pbix?dl=0

Regards,

Daniel He

[RMDNA]

Hi @agusti_oliveres,

Actual slicers can be synced across pages, but I don't believe using table filtering carries between pages without drilldown.