PowerBI Matrix Columns Sort

[rvdhorst1]

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?

[AliceW]

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.

[rvdhorst1]

Thank you Alice,

Only my Column name is now 1 2 and 3 not the Fiscalyear name

Thank you

Raymond

[AliceW · Accepted solution]

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.