Matrix Layout Advice

[cheid]

I have a question and need some advice about matrix layouts.  Below is the current layout of my matrix.  I want it to look like the screenshot under final result below.  Is it possible to create a relationship between the column names in the data file to the measure names in the target file so that I end up with the final result shown below.  I am just looking for idea or thoughtson whether this can be done.  Thanks.

Current Layout

Data File

Target Values

Final Result

[grazitti_sapna · Accepted solution]

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! 

[Irwan]

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.