collapse all and expand all functionality over a button for matrix

[sanjanarama]

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.?

[v-angzheng-msft · Accepted solution]

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 stories

Result:

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.