Forum Discussion

rvdhorst1's avatar
rvdhorst1
New Member
2 years ago
Solved

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...
Need Help
  • AliceW's avatar
    AliceW
    2 years ago

    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.

AliceW's avatar
AliceW
Power Participant
2 years ago

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's avatar
rvdhorst1
New Member
2 years ago

Thank you Alice,

 

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

 

 

Thank you

 

Raymond

 

  • AliceW's avatar
    AliceW
    Power Participant
    2 years ago

    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.