Make hierarchy sort by its item ID not alphabetical

[crln-blue]

Hello!

I made a hierarchy using the Path Function and when I used it to the Matrix table, it automatically sorts alphabetically. Is there a way for the hierarchy to NOT sort alphabetically? I fixed my item ID since I'm assuming that the sort will follow the item ID but it does not.

The sort by item ID is important because it's already arranged in my desired sort.

Thanks!

[Anonymous · Accepted solution]

@crln-blue , You need to sort the column by ID. Please select the colum you want to sort and under column tools, you will find the option to do so.

Please note: Both the columns should be in the same table.

Did I solve your problem?

If yes, please mark my solution Accepted!

[amitchandak]

@crln-blue , You can create a sort column and use that.

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

[crln-blue]

Hello @amitchandak ,
Thanks for the link. I tried it but I think the column that will be used for sorting should also be on my visual. Unfortunately, I can't try the other method because my table is a DAX table.

[Anonymous · Accepted solution]

@crln-blue , You need to sort the column by ID. Please select the colum you want to sort and under column tools, you will find the option to do so.

Please note: Both the columns should be in the same table.

Did I solve your problem?

If yes, please mark my solution Accepted!

[crln-blue · Accepted solution]

I finally saw this feature. I noticed that in the report view, I need to highlight the column to be sorted and the button will appear where I can set which sort column to be used. Thanks!

[crln-blue]

Hello @Anonymous ,

I tried the method you told me but it's still not reflecting. I didn't add the column on the visual since I don't need it. I just want it to be sorted in that way. 
My data is like this:

My expected output

• Collections
• Total Materials
  • Imported
  • Local
• Operating Costs
  • Rent 
  • Electricity

Ouput from Matrix Table

• Collections
• Operating Costs
  • Electricty
  • Rent
• Total Materials
  • Imported
  • Local