CODEWITHSUNDEEP
excelpowerbireportmultiple-columnsdata-transform
Kaladin
Kaladin

Reputation: 3

Showing column names in rows, Power BI report

at start I have this table:

enter image description here

From this data I've created this report (on the left table based on slicer placed at the right):

enter image description here

Is there a way to show it like that in Power BI (instead of showing column names horizontally I'd like to show it vertically):

enter image description here

I've tried pivoting/unpivoting columns and using headers as first row + transposing, but it seems like those solutions don't work because of column with companies names.

Thanks for reply.

Upvotes: 0

Views: 2867

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60389

  • Transform (in Power Query)
  • Delete the company name column
  • Unpivot all the columns
  • Group by the Attribute column with the Sum operation

enter image description here

Upvotes: 0

Related Questions