Forum Discussion
Post ProdigyFlipping Axis in matrix
Super UserHi HenryJS ,
Go to the options of the matrix and turn on the option Show in Rows.
This option will place your measures on rows instead of columns.
Post ProdigyMFelix can you provide more information or a screenshot as I can't see that option!
- tex628
Community Champion
- HenryJS
when I add two measures into the matrix it puts both in the columns?
I want them to be displayed as rows on top of eachother as I've marked below in red lines
I had the same exact problem, it is so annoying. Anyone who has any answers please help.
The only solution I have found is to make a change in the structure of your data when you bring it in to Power BI. If you create a category column that list the category (or whatever you want your rows to be) for each row of data in your table, you can then use that as your rows field in the matrix visualization. You should then be able to use your measures as the values field for the Matrix. The caveat to this solution is that if you can't add more options to your category column after you have loaded the data into Power BI (at least I don't know how to). I hope this helps.
This seems like a problem that should be fairly common so if anyone has any easier solutions please post!