Custom sorting in PowerBI chart

Question

Recently I came across one issue in which I need to show the column order as per my defined way in PowerBi report. Thing is, PowerBI sorts the columns in either Ascending(A->Z) or descending(Z->A) order, then if one has to apply for his custom order how he should achieve this?

Answer 1

• We need to add columns to our source data and populate it with values for the desired sort order and then select the column you want to custom sort and click Modeling > Sort by Column.

•  Select the new column as the SortBy column for the existing column, like in the screenshot: The SortCategory column is used as the sort order for the Category column.

• Next, create a chart and the categories on the axis will be sorted according to the values of the SortCategory column.