Change the order of the matrix columns

[joaoandrebs]

I have a database that has some "codes" that are from the Statement column. These codes, as in the first image, need to be in this sequence of PI-1, PI-2, PI-3... (I have 62 of these codes for each Area and Time = "Team" and english).
Ok, so far so good, but I wanted to make a matrix, based on these codes, and for some reason they come in alphabetical order (image 2).
I've tried everything but I haven't found a way to change this.

 image 1 - correct order

 image 2 - incorrect order

Resume: I need change the sequence order of the columns of image 2 to image 1.

[v-achippa]

Hi @joaoandrebs,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Jihwan_Kim for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @joaoandrebs,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @joaoandrebs,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I think it helps to have sort order column for Statement column.

Please check the link down below from Microsoft.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column