Forum Discussion
How to Re-Arrange Columns in Matrix mode
Hi There
I keep getting this really annoying issue where the column won't stay put:
The values are placed in rows and I want to get 2020 on the first sub-column then 2021 on the secondary column as shown below
Any Idea on what I need to do to be able to sort the columns so they don't move according
william0076 , CLick on the column for which you want to define the sort column you will have an option.
Refer to this video : https://youtu.be/KK1zu4MBb-c
4 Replies
william0076 , I am assuming you are looking for sort order for matrix column(pivot)
You have to create a sort column for that and mark that as the sort column and use that.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hey
Thanks for the help but i keep trying to do this but it's only available for other visuals and not the matrix
Update: I don't seem to have Sort Column on my version of PBI when i click Matrix:
william0076 , CLick on the column for which you want to define the sort column you will have an option.
Refer to this video : https://youtu.be/KK1zu4MBb-c
