Matrix visualization - sorting first and third level is ok, the second level only alphabetically

[Stelian]

I've created a power bi profit and loss report with matrix visualisation and I have three levels of accounts.

sorting first and third level is woring, the seond level is sorting alphabetically

I've assigned columns for each level as below

When I try to sort "Account Structure Level 1" by column ord_1 I receive the following error message:

Can you tell me please what should I do?

Thank you

Stelian

[Anonymous]

Hi @Stelian ,

Please check your value. matrix has requirements for the data it will sort.

You may also refer to this thread：

powerbi - Why do I get "Sort by another column" error Power BI - Stack Overflow

Best regards.
Community Support Team_Caitlyn

[Stelian]

Thank you!