The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
When using a matrix visual, I select an item and then drill thru to another page, when going back to the original page, is it possible to return to the same item on the matrix visual using bookmarks?
Solved! Go to Solution.
Hi @Rnaval,
Thank you for reaching out in Microsoft Community Forum.
Please try using below workaround this might helpful to resolve youur issue;
1.Add a slicer for the field you're drilling through on (e.g., "Item Name" or "ID") to your matrix page.
2.Sync the slicer across both the main and drill-through pages (View → Sync Slicers).
3.Drill-through using that field, so the slicer auto-filters both pages to the selected item.
4.When using the back button, the matrix shows only the selected item — no need to scroll.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
Hi @Rnaval,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.
Thanks, I did review your response, I'm still looking for a real solution which I feel can be implemented to resolve this issue.
Hi @Rnaval,
Thank you for reaching out in Microsoft Community Forum.
Please try using below workaround this might helpful to resolve youur issue;
1.Add a slicer for the field you're drilling through on (e.g., "Item Name" or "ID") to your matrix page.
2.Sync the slicer across both the main and drill-through pages (View → Sync Slicers).
3.Drill-through using that field, so the slicer auto-filters both pages to the selected item.
4.When using the back button, the matrix shows only the selected item — no need to scroll.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
Hi @Rnaval Bookmarks do not retain interactive states like the selected item in a matrix visual after switching pages. Instead, use drill-through functionality to pass the context of the selected item to another page. Add a back button on the drill-through page to navigate back, keeping the original selection intact.
I do have a back button, it does not return me to the selected item on the matrix, it returns me to the top of the matrix.
@Rnaval Could you try syncing a slicer across pages? This will capture the selected item from the matrix and maintain that context when you return via the back button
That won't work in my case. Just to clarify the matrix has thousands of rows, lets say I scroll down to row 500 and select an item and drill thru to another page, when I hit the back button, it returns me to row number 1 instead of row 500. I realize this may require some creative programming to achieve the results I'm looking for.
@Rnaval There is no direct way to restore the exact scroll position of the matrix using standard Power BI features. You could explore custom visuals or use Power Automate to store the selected row and apply it on return or embedding in an application with JavaScript might allow you to capture and restore the scroll position
Yeah, that's all beyond me, I'm still learning the basics of Power BI...
Hi @Rnaval,
Thank you for reaching out in Microsoft Community Forum.
Thank you @Akash_Varuna for the helpful response.
Power BI does not currently support retaining the scroll position in a matrix visual after drillthrough. When you return to the original page (even using a back button), the matrix resets to the top.
Since you're just getting started with Power BI, advanced workarounds like Power Automate or JavaScript embedding may be out of scope for now.
please follow below alternatives to resolve the error;
1.Use slicers to narrow down the matrix results and reduce scrolling.
2.Show the selected item on the drillthrough page using a Card visual, so you can easily identify it again when you return.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.