Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
81 | |
52 | |
39 | |
34 |
User | Count |
---|---|
95 | |
78 | |
52 | |
49 | |
47 |