Custom Sorting

[castrofg]

How do I custom sort? My Total Revenue doesn't include all the categories above it, so I need to drag some below it to add a new column.

Is there a drag and drop function? Or do I need to add a column in my excel workbook to include a sorting number?

Thanks!

[AndersAano]

If your excel sheet contains a separate column with the sorting order you want, you can use that to get the sorting right in Power BI:

In this case, Column E is the category names i want to display. Column D is the sorting order (alpha-numerical):

In Power BI, I select the filed "displayName" in the data-tab, and select "Sort By" in the ribbon. In that drop-down menu, I select "id":

Sort order in Power BI:

best regards Anders