Forum Discussion

e175429's avatar
e175429
Helper IV
2 years ago
Solved

How do I invert a matrix graph?

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:

 

 

  • 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

3 Replies

  • 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

  • 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