Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
This can't be this difficult but for the life of me I can't figure it out. I have created this matrix table below already:
Which involves this type of config:
And then it dawned on me, why can't I just use filtered columns and count/sum values for each column to achieve the same result but cleaner. But when I started adding the columns, they expand down instead of left to right. Please advise how to have the matrix table always expanded to show all columns left to right, similar to the one above. This is what I've created so far, but can't get it to expand the 2nd column "Column Portfolio" left to right (there will be many more columns to add):
Thank you for your time!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 51 | |
| 44 | |
| 43 | |
| 39 | |
| 32 |