Forum Discussion
Filter a page from a table
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.
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
2 Replies
Hi agusti_oliveres,
Actual slicers can be synced across pages, but I don't believe using table filtering carries between pages without drilldown.
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
