Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Is there a way to have granular control over expanding/collapsing on row headers in a matrix visual? Say I have a parent record at the top level and for each child record I want to display a few attributes along with the values for the child record. The default behavior for drilling is that each row header representing an attribute is drillable. How can I force power bi to only drill on the row headers I decide? is it possible?
@Anonymous did you tried turning on +/- on format pane?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Another user had the same situation, but unresolved.
https://community.powerbi.com/t5/Desktop/Expandable-Table-Visual/m-p/667579/highlight/false#M321117