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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello,
I am enjoying the features and functionality of the new matrix, but the layout of the original version displayed the data I am trying to show off perfectly, whereas the new version leaves something to be desired.
I've included two examples below of how the new matrix and previous matrix lay out the data. The examples are using dummy data.
The old layout would not duplicate values if they were relevant on multiple rows, but the new one seems to. I've tried moving around the rows and columns but I haven't managed to recreate the old layout.
New Layout
Department | Amount | Year opened |
Finance |
|
|
Jack Robinson |
|
|
Current Account | 158.35 | 01/03/2015 |
Savings Account | 450.00 | 18/02/2016 |
Credit Card | 12.50 | 10/08/2015 |
Tim Jenkins |
|
|
Current Account | 680.52 | 25/06/2001 |
Savings Account | 14200.00 | 25/06/2001 |
HR |
|
|
Dan Stevens |
|
|
Current Account | 252.98 | 08/08/2007 |
Credit Card | 208.65 | 08/08/2007 |
Old Layout
Department | Name | Account Type | Amount | Year Opened |
Finance | Jack Robinson | Current Account | 158.35 | 01/03/2015 |
|
| Savings Account | 450.00 | 18/02/2016 |
|
| Credit Card | 12.50 | 10/08/2015 |
| Tim Jenkins | Current Account | 680.52 | 25/06/2001 |
|
| Savings Account | 14200.00 | 25/06/2001 |
HR | Dam Stevens | Current Account | 252.98 | 08/08/2007 |
|
| Credit Card | 208.65 | 08/08/2007 |
Hopefully the above portrays what I'm trying to ask, but if not, let me know and I'll try and elaborate.
Thanks!
Solved! Go to Solution.
@BroomJ This could just be a matter of turning off the "Stepped Layout"
You can find that under the Format paintbrush -> Row Header section, turn it off and it looks like the old matrix
Hi,
Still i can see drill down for my matrix.
in the above matrix color nm and batch id should not go drill down i want show in right side only,i selected stepped layout property,but its not showing to me.
Can you please help me on this.
@BroomJ This could just be a matter of turning off the "Stepped Layout"
You can find that under the Format paintbrush -> Row Header section, turn it off and it looks like the old matrix
Perfect, that's exactly what I was looking for.
I must've looked through all of the formatting options 5 or 6 times and I somehow completely missed that option every single time.
Thank you very much!