Matrix Measures or Values on Rows instead of Columns
We need Matrix’s to have the ability to move Measures or Values to rows instead of Columns. This is a definite must have!!! I was in the process of doing a pilot roll out of Power BI to my management team and when this question came up it was a huge miss and got a tremendous amount of groans. This is an everyday view we use and really need this for Power BI to cover the basics. I love the program but we really need this. Please help!
To elaborate, if I have sales, quantity sold, asp (average sales price), COGS, Gross Profit and Margin, There’s no way to look at this month over month when the measures are stuck on the columns. It needs to be able to showcase on rows.
Thanks for your consideration!
We added this feature to our August update to the Power BI Desktop. Read all about it in our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#valuesOnRows
We need Matrix’s to have the ability to move custom measures to rows instead of columns
Josh Myers commented
Please reopen the idea. It is not added as a solution as it was originally described. I would like to add a measure to the field wel: row
please add this asap
You Should Reopen it, we need to put measures on the rows in the Matrix and not in the columns
Jim Richards commented
We need to be able to put multiple values on rows in the Power BI Matrix visual rather than on just columns.
María Garrido commented
still not available in desktop :-(
still not available in desktop :(
Niek Verhoef commented
Great work on the matrix visual Microsoft!
Could you add the functionality to order the values by column header?
When we select a column header in the table visual it gets ordered based on the values in that specific column, we would like to see that in the matrix visual as well.
Keep up the good work!
Format Tab > Values > Show On Rows 'On'
I missed this for a while too...
John Poston commented
Hi Sawan and Amanda,
Thanks for working on this. I still don't see this feature available after I downloaded the most recent Desktop version, though. Am I missing something?
I'm aware of Matt Allington's post (http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/) but would prefer a similar functionality to Excel's pivot tables.
If this is do-able now, and I'm just not seeing how to do it, could you point me in the right direction?
Thanks for all your hard work : ) Your team is doing great things.
Sawan Musthyala commented
Looks like this is now available. Download latest version of Power BI Desktop.
See that a new Matrix visual has recently been released with ability to drill down when multiple row or column dimensions are selected in a hierarchy. I have installed this through the Preview Features option. However back Regarding the issue of being able to put calculated measures in rows rather than having to put them in columns as discussed below in the thread. What is the ETA for release of this very necessary enhancement?
Anthony Hipperson commented
Please add ASAP!
Yes, I have just run into this requirement as well for desktop. Please can we have it?!
I found this feature only in the GUI as well, sneaky folks at Microsoft PELASE put this in the Desktop client ASAP!
Thanks for the update Amada - this will be a much anticipated feature !
Thibaut Quignon commented
I haven't found the Option "Values - Show on rows On/Off" in the web client for the Matrix, is it still available?
Good shout thank you, I see it under values on the web client but not the desktop client. Please push this out asap would be a massive win for us and at the sounds of it many others.