Create custome sort in Power BI

In Power BI, you can achieve custom sorting by creating a separate column that defines the sort order for your "state" column. Here's a general guide:
Create a Sort Order Column:

• Create a new column in your table, let's call it "Sort Order."

• Assign a numerical value to each state based on your desired sorting order.

Sort by the New Column:

• In your visualizations or tables, sort by the newly created "Sort Order" column rather than the original "state" column.

This way, you can define a custom sort order for your states independent of alphabetical order.
For example, if you want to sort by population size, you might assign a number to each state based on its population.
If you provide more details about your sorting criteria, I can give you a more specific example.

If you want to sort your "state" column based on a custom order like "planned - New - Accepted - done - Resolved - Closed," you can follow these steps:

Create a Custom Sort Order Column:

Create a new column (let's call it "CustomSortOrder") and assign a numerical value to each state based on your desired order. For example:

Planned: 1

New: 2

Accepted: 3

Done: 4

Resolved: 5

Closed: 6

Sort by the Custom Sort Order Column:

In your Power BI visualizations or tables, sort by the "CustomSortOrder" column rather than the original "state" column.

This way, your states will be sorted according to the custom order you defined in the "CustomSortOrder" column.