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:    
  • gmsamborn's avatar
    2 years ago

    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