Forum Discussion
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!
hello cheid
the final result should be plausible, however relationship between column and measure is not possible at this point as far as my knowledge.
Please share your sample data in table form or pbix that represent your original data so many expert here can help you (remove any confidential information).
Thank you.