topic How do I invert a matrix graph? in DAX Commands and Tips

How do I invert a matrix graph?

e175429 — Fri, 29 Dec 2023 19:03:54 GMT

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:

Re: How do I invert a matrix graph?

gmsamborn — Fri, 29 Dec 2023 19:55:03 GMT

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

Re: How do I invert a matrix graph?

e175429 — Fri, 29 Dec 2023 19:58:34 GMT

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

Re: How do I invert a matrix graph?

gmsamborn — Fri, 29 Dec 2023 20:02:42 GMT

I'm glad it helped.

Happy New Year