Description:
Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the Matrix/Table to the top instead of preserving the user's previous position.
This can be frustrating when working with large datasets, especially when the selected row is far down in a long Matrix or Table. Users must manually scroll and relocate the exact item they were analyzing before continuing their work.
Suggested Enhancement: When returning from a Drillthrough page, Power BI should restore the original visual state, including:
- Scroll position within the Matrix or Table
- Expanded/collapsed hierarchy levels
- Selected row or record
- Visual focus and viewport location
Benefits:
- Improved user experience and navigation
- Faster analysis of large reports
- Reduced need for repetitive scrolling and searching
- More intuitive drillthrough workflow, similar to modern web applications that preserve page state
Example Scenario: A user scrolls to row 250 in a Matrix visual, drills through to view transaction details, and then clicks Back. Instead of returning to the top of the Matrix, the report should restore the view to row 250 with the same hierarchy expansion state, allowing the user to continue analysis seamlessly.
Business Impact: This enhancement would significantly improve usability for enterprise reports containing thousands of rows and deeply nested hierarchies, where users frequently drill through multiple records during analysis.
