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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Dear all,
I would like to kind of lock the matrix visual. The User should not be able collaps the matrix. It should always be expanded to all levels. Is that possible?
Thanks in advance.
In power bi desktop or editing the report in the service, you should be able to fully expand the Matrix the way you'd like it to be displayed, and then under fromat visual-> general->Header Icons->Icons you can toggle off the options you don't want them to be able to utilize ie. drill on drop down, show next level, etc. Let me know if that accomplishes what you're looking for.
Thanks for the tip. But the user still can collapse / expand with right-mouse-click.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 18 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 47 | |
| 38 | |
| 36 | |
| 25 | |
| 20 |