Transpose table in report visual in Power BI Desktop

Question

I had a table which looks like this

I want to build a matrix which shows indicators in the rows and years in columns

How can I do this?

Answer 1

• Select query editor and right click on your existing query,
•  Select Reference.
•  And it will create a new query
• Then select the Transform tab.
• And select bottom part of  Use First Row As Headers button,
• And select Use Headers as First Row.

• Select on Transpose.
• and select on Use First Row As Headers button 
• and then click on the Home tab and Close & Apply

Do you wish to learn the tool in-depth? Come to us and sign up for this Power BI Certification