Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
Hi @agusti_oliveres,
Actual slicers can be synced across pages, but I don't believe using table filtering carries between pages without drilldown.
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |