Forum Discussion
PowerBI Matrix Columns Sort
Hi All,
I have a column with the name FY (Finacial year). It looks like
2020-2021
2021-2022
2022-2023
etc
I use this with a Matrix in the columns entry. Only this one can't be sorted. I want this Column is sorted as
2022-2023
2021-2022
2020-2021
Can this be done?
Yes, that is the Duplicate column. You will have two - your initial one and this new one. Order the initial one based on the Duplicate and you'll be able to sort it in the matrix.
3 Replies
AliceWPower Participant
The simplest way I can think of is you create a new column:
FY for Ordering =
switch(Dates'[FY],
"2020-2021", 3,
"2021-2022", 2,
"2022-2023", 1
)
Then click on the original colum, FY. Go to 'Column tools' in the top menu, then 'Sort by column', then this new column.
Thank you Alice,
Only my Column name is now 1 2 and 3 not the Fiscalyear name
Thank you
Raymond
- AliceW
Yes, that is the Duplicate column. You will have two - your initial one and this new one. Order the initial one based on the Duplicate and you'll be able to sort it in the matrix.
