Matrix Layout Advice

Hi cheid,

You can acheive this by unpivoting your measure columns e.g. totalloads, Miles etc. in the same table except all the dimensions, or

To acheive this you should unpivot your measures in the table and create a helper table to show the Values on the table.

So your original table will have unpivoted KPIs (Measures) in a single column and the dimensions would come from the dimension table which you've created.

Kindly see attached sample solution, let me know if you have any questions.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!