Custom Sort in PowerBI Chart

Question

I recently ran into one problem in which I need to show the column order according to my specific way in a PowerBi report. The fact is that PowerBI sorts the columns in ascending order (A-> Z) or descending (Z-> A), then if you need to apply your order, how should it achieve this?

Here is an example

Here we see that the order along the X axis is increasing, or we can show its descent, but what if I would like to sort the order in relation to my need; may be as follows:

1.2 Wheel preview → 1.2 GTR → 1.2 Ultra → 1.2 RTR

. Is it possible on the PowerBI desktop when creating a report, if so, then the guidelines that should be followed will be well appreciated. :)

Thanks.

Answer 1

Add a column to the source data and fill it with values ​​for the desired sort order. Then select the column that you want to customize, and click Simulate> Sort By Column. Select the new column as the SortBy column for the existing column, for example, in the screenshot: the SortCategory column is used as the sort order for the Category column.

Now create a chart and the categories on the axis will be sorted according to the values ​​of the SortCategory column.