Forum Discussion
Resolver Icollapse all and expand all functionality over a button for matrix
is there a posibility to have a button as "expand all" and "collapse all" to expand and collapse all records in a matrix.
I know there is a functionality in matrix visual if we hover over we would get options to move to next hierarchy or expand. but can we implement this over a button.?
Hi, sanjanarama
Way 1: Drill Up and Drill Down
With this way you don't even need to create additional buttons.Drill down and drill up in a visual
Way 2: Bookmarks + Buttons
Create bookmarks to record the expanded and collapsed state of the matrix, and create buttons to link to the bookmarks.
Create report bookmarks in Power BI to share insights and build storiesResult:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-angzheng-msft
Community Support
Hi, sanjanarama
Way 1: Drill Up and Drill Down
With this way you don't even need to create additional buttons.Drill down and drill up in a visual
Way 2: Bookmarks + Buttons
Create bookmarks to record the expanded and collapsed state of the matrix, and create buttons to link to the bookmarks.
Create report bookmarks in Power BI to share insights and build storiesResult:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.