The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Is there an easy way to collapse all rows in Matrix chart with "+/- icons" rather than manually clicking on "-" icon next to each expanded row?
Thanks
Solved! Go to Solution.
Hi @Peter_ ,
If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:
This works with any number of levels you may add to your matrix, and on stepped and non stepped layout.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Peter_ ,
If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:
This works with any number of levels you may add to your matrix, and on stepped and non stepped layout.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Miguel.
Thank you very much for the solution to this question.
Is there a way to do this without right-clicking the symbol?
Like in a button or an option visible to the web user?
Thanks.
Hi @danielcvs,
On the icons on top of the visual you have 4 buttons
Arrow pointing up - goes to the top level
Arrow pointing down - turns on click on mouse to drill down
Two arrows - go to next level (does not show higher level)
One splitting arrow goes to the last level
This should help you.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português