cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Matrix +/- feature

Hello all, 

I have a matrix as follow:

app.PNG

In this format, in roder to toggle up or down, I have to click +/- sign for each category. 


Well, my question is: Can I provide a function or measure that Expand/collapse all categories with just clicking one parameter or so? 



1 ACCEPTED SOLUTION

Accepted Solutions
Iamnvt Member
Member

Re: Matrix +/- feature

yes, then you need to use Bookmark feature:

1. Bookmark the page after expand all

2. Bookmark the page after collapse all

3. Insert 2 buttons; assign the bookmark for each button.

4 REPLIES 4
Highlighted
kcantor Super Contributor
Super Contributor

Re: Matrix +/- feature

@elahemeydani 

This could be accomplished using Bookmarks and Buttons. I have a report that I use the drill down from Month to Week either open or invoiced by selecting a button linked to a bookmark. The simply choose Invoiced by Week, Invoiced by Month, Open by Week, or Open by month. Using the bookmarks I change both the axis and the calculation. The axis can be changed through multiple levels before the bookmark is set. 

https://www.wiseowl.co.uk/power-bi/exercises/power-bi-desktop/drill-through-and-bookmarks/4361/



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Iamnvt Member
Member

Re: Matrix +/- feature

hi,

 

you can right click to the +,- button. It has expand all, collapse all function there.

Re: Matrix +/- feature

@Iamnvt 

Thank you for your help. 

Can I implement this in a separate button on top of the page??

Iamnvt Member
Member

Re: Matrix +/- feature

yes, then you need to use Bookmark feature:

1. Bookmark the page after expand all

2. Bookmark the page after collapse all

3. Insert 2 buttons; assign the bookmark for each button.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 3,564 guests
Please welcome our newest community members: