Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I have two pages in my report.
1. Page 1 (Tracker): It contains a matrix. The columns are name of list items and their monthly tracker.
2. Page 2 (Details): This page is detail summary of the list items present in Page 1. This page includes a slicer from where User selects the list item and then check the details which are in 4 different tables.
I want to click on one list items from Page 1 and then it should take me to Page 2 with the same value selected in the slicer present.
Solved! Go to Solution.
Hi @Anonymous
You can use drillthrough option to navigate another screen with all filter. You need to right click the cell and click on Drillthrogh.
Before than you need to put your filter column in 2nd page in drillthrough
Reference - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=powerbi-desktop
2nd Process
Create Drillthough button in power bi, so you no need to right click and select drillthrough. Left click on this button will works for you
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons
If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Proud to be a Super User! | |
Hi @VijayP
It's not about Slicer Sync. I want to click on one row in Matrix which should navigate me to another page and the same value should be selected in the slicer present at destination page.
Hi @Anonymous
You can use drillthrough option to navigate another screen with all filter. You need to right click the cell and click on Drillthrogh.
Before than you need to put your filter column in 2nd page in drillthrough
Reference - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=powerbi-desktop
2nd Process
Create Drillthough button in power bi, so you no need to right click and select drillthrough. Left click on this button will works for you
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons
If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Proud to be a Super User! | |
@Anonymous
You can use SyncSlicer option in view Table !
Also to know more go to this page https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages
Proud to be a Super User!