The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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!
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
38 |