cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erikskov
Advocate II
Advocate II

can you pivot data values from column to on row

Withing Power BI creating a report from a published data source, can you pivot the matrix view to get values on row instead of the defaul values on column?  The desired functionality is identical to using a pivot table and moving the 'values' from column to row.  Unless I'm missing something I don't see how to do this within the web application.

7 REPLIES 7
jphamman
New Member

It was not possible previously but now the Matrix in PowerBI allows you to group values in rows by going to format properties and looking for "show in rows" under Values

xxcorpxx
Advocate I
Advocate I

 

I can't do 1/4 of my reports because of this lacking feature.

 

I need to see values in Rows that are drillable/expandable to different levels with Months in columns.  I can't figure out any visual that will give me this report.

2017-07-26_16-05-39.png

 

andre
Memorable Member
Memorable Member

The Matrix control in the Service is lacking some of the features of the Excel matrix control (like pivoting on columns).  Hopefully all of the missing features will make it back into the service soon.

You can change fields from rows to columns in on a Matrix when Editing report

 

 

Untitled.png

Konstantinos Ioannou

Hi...

 

But @konstantinos, the problem is: if you change '[Name]' from rows to columns, the measures [Value] and [Value2] always is in the columns... 

 

I want show:

---------- NameA, NameB, NameC

Value           10           20         30 

Value2         40           50         70

did you ever find a solution for this?

Greg_Deckler
Super User
Super User

Not aware that you can do that in Power BI service, you can use Power Query and use the PIVOT or UNPIVOT functionality there.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors