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.

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.