Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

I had a table which looks like this

enter image description here

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

How can I do this?

1 Answer

0 votes
by (22.5k points)
  • 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.

enter image description here

  • 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

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories