How can I change row places of subcategory as below?

[Anonymous]

I have two classification groups. Sorting for level 1 is fine, but I need to change level 2 sorting as I numbered in the picture. How can I handle that?

[amitchandak]

@Anonymous ,

First, try to sort first column.

Create a column where you define the sort order and mark that the sort column.

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

[Anonymous]

Create a table with each category listed as rows then in the column next to it enter in the order.  

once thats done you can connect the 2 tables and then sort your main table by the ranking table 

[Anonymous]

Thanks for your reply. However, I did not get an idea. Can you elaborate on your answer please? @Anonymous 

[Anonymous]

select enter data then enter each class and then number them based on your order.  

then connect the entered data table to your other fact table and then select your class and say sort by rank order in your entered data table 

[amitchandak · Accepted solution]

@Anonymous , refer if this can help

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi