Search code examples
excelpowerbireportmultiple-columnsdata-transform

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.


Solution

    • 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