Allow matrix visuals to automatically expand to the lowest hierarchy level when switching between bookmarks, while maintaining the slicer selection.
Hi everyone, I think im hitting a design limitation in Power BI, but i wanted to make sure. I’m building a single page report that uses bookmarks to simulate multiple pages, but I’m running into issues with Matrix behavior and bookmark state. The simplified situation looks something like this. * I have **Bookmark 1** (landing view) with: * A table visual showing Projects (high-level view) * A slicer for Projects * The user looks for Projects that he deems have to be inspected and selects a specific Project on the Slicer. Then I use a button to navigate to **Bookmark 2**, which: * Has a matrix table visual * Has more detailed hierarchy levels * Is meant to show more complex details for the selected Project What's the goal: When switching from Bookmark 1 -> Bookmark 2: 1. The slicer selection must persist * The second matrix must stay filtered to the selected project 2. The second matrix must always be fully expanded to the lowest hierarchy level * I don’t want users to manually click expand 10-20 times * It must open fully expanded automatically But what i have currently arrived at. If I: * Uncheck **Data** in the bookmark 2 settings * Slicer state persists * BUT the matrix collapses * Check **Data** in the bookmark 2 settings * Matrix stays expanded * BUT slicer state resets, and the selection is gone. So is there a way to achieve the goal, or is this impossible?