0 votes
1 view
in BI by (17.6k points)

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?

1 Answer

0 votes
by (47.2k points)
  • 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.

image

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

image

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !

Categories

...