March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear Fellows,
I want to create matrix with expanded row headers by default without + - symbols.
Eatlier, we were having 'Stepped Layout' button, if we turn it off that used to give me desired output.
Now power BI has recently created separate setting as 'Layound and style presents' where I need to setup Layout as either as 'Tabular' or 'Outline' to get my desired expanded matrix but even after choosing 'Tabular' or 'Outline' layout, it is not showing me expanded matrix and I can still see collapsed matrix with + symbols.
Your help will be appreciated.
Thanks!
Solved! Go to Solution.
Hi @dhbd ,
in my example, i got a Matrix like this:
Now in my format pane, layout and presets i choose tabular, and enabled repeat row headers:
Now i go back to my matrix and set drill mode to on, and expand all down levels, as shown bellow:
At this point, my Matrix look like this:
Now i go back to format pane and disable +/- icons
This is my final result:
Hi @dhbd ,
in my example, i got a Matrix like this:
Now in my format pane, layout and presets i choose tabular, and enabled repeat row headers:
Now i go back to my matrix and set drill mode to on, and expand all down levels, as shown bellow:
At this point, my Matrix look like this:
Now i go back to format pane and disable +/- icons
This is my final result:
@dhbd - Try the below to see if this resolves your issue:
Step 1: Click on expand all level
Step 2 : Turn off the icons
Output :
Hope this helps.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
73 | |
68 |