Solved: Matrix Visualisation with data in rows now columns

JamesCH · ‎10-13-2016

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

ImkeF · ‎10-13-2016

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

BhaveshPatel · ‎10-13-2016

Please follow along the screenshot to see the expected results.

Do not promote headersReversed RowsTransposed RowsUse a fill down feature under Transform TabCreate Conditional column for Sorting of the month name by month no.Final 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.

JamesCH · ‎10-13-2016

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?