Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JamesCH
Frequent Visitor

Matrix Visualisation with data in rows now columns

Hi all

 

I have some data on sales values and volumes that I need to display. Using a matrix I can get them all on one row (see first table below) but I want to show 'value' on one row and 'volume' on the next. (see table 2 below). There does not seem to be an easy way to do this. Any ideas

 

picture_1.JPG

1 ACCEPTED SOLUTION

Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:

https://bondarenkoivan.wordpress.com/2016/10/07/how-to-organize-measures-in-tables-horizontally-in-p...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

3 REPLIES 3
BhaveshPatel
Community Champion
Community Champion

Please follow along the screenshot to see the expected results. 

Do not promote headersDo not promote headersReversed RowsReversed RowsTransposed RowsTransposed RowsUse a fill down feature under Transform TabUse a fill down feature under Transform TabCreate Conditional column for Sorting of the month name by month no.Create Conditional column for Sorting of the month name by month no.Final resultsFinal results

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

hi thanks for that.

 

The data I have is already in a table and is selected via a slicer. What I don't understand from your solution is how I get that data into this table in the first place?

 

 

Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:

https://bondarenkoivan.wordpress.com/2016/10/07/how-to-organize-measures-in-tables-horizontally-in-p...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.