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!
Hi everyone – quick update to say this is definitely something we’re planning to address and add to our matrix visual. We’ve got a set of enhancements coming to the matrix, so please stay tuned!
thanks for supporting the idea
Martin Soanes commented
any update on when this feature will be made available - last comment from Admin shows "planned" back in January. Many thanks in advance
John Wittenbrook commented
Any chance we can have this in the April release?
There is a work-around but an out-of-the-box solution would be more productive and one more thing that is challenging. Even if you manage to do the work-around, how do you do Conditional Formatting on it, these are different measures with different targets. I hope that gets considered to when this becomes materialized.
John Wittenbrook commented
everything is critical, but this one is really critical +1000 votes
We need update/function asap.. Please prioritize in your next update
Any update?! This is a critical issue to have
Any news on this? It just came up with a meeting a was having also trying to launch this tool.!!!!
Kateryna Chkalova commented
Hi, could you please inform when the new matrix visual will be available?
Anthony Newell commented
Just come across exactly the same issue. Any ETA on this?
Stefan Vogt commented
Please, prioritize this feature!
JAVIER VEDOYA commented
ANY NEWS ON THIS UPDATE?
Cameron Snow commented
Came across this issue today trying to build a trending view in the dashboard. While I still believe Power BI is the best place to assemble the data and calculate the measures I now have to export to Excel to achieve Management's desired format. In general the ability to cross-tab the data is a critical function for data analysis and I am excited that this will soon be added.
Steve Ward commented
I didn't realise this wasn't possible until today (Power BI does so much already I assumed this would be fine). Good to hear it's planned. Hope you guys understand just how much the monthly updates are anticipated? I've not been this excited about reporting - ever.
Hope this one arrives soon - but not before printing from the Power BI Desktop!!!
Is this also for the data tab?
In the Interim, what is the alternate way to achieve this?
Morven Ballard commented
Do you have an ETA for this please? It really is a huge disadvantage not being able to have values on rows.
Making this change would be an absolutely HUGE change. Gives analysts a way to interrogate data more easily to answer questions.
Looking forward to this being implemented.
how is this not #1