0 votes
1 view
in BI by (10k 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 (20.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 !


Categories

...