How do I invert a matrix graph?

[e175429]

Hey Yall,

How do I invert this graph:

I want the Year to be the columns and everyting from "Events-Total Activites" to be the Rows?

Like this:

[e175429]

You are the absolute best! It was so simple and now I feel foolish that I couldn't figure that out. But thank you so much lol

[gmsamborn]

I'm glad it helped.

Happy New Year

[gmsamborn · Accepted solution]

Hi @e175429 

I started with a matrix with Year on rows and various calculations on columns.
Next with the matrix selected, go to the Format pane and open up Values.
At the bottom, you will see Options. Open that and select Switch values to rows.
Finally, you will have to move Year from Rows to Columns.

Invert a matrix.pbix