Change the order of a group

[KStock]

Is there a way to set the order for a group? I'd like to change the order to:
Gross Margin

Expenses

Amortization

Interest

Taxes

[Chris12]

If you want the obvious fix vote for https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16895230-ability-to-specify-custo...

[Greg_Deckler · Accepted solution]

Generally, you need to go into your query and create a "sort" column which essentially is a column that looks at your other column and returns the integer sorting that you want. So, basically a conditional column that is "if [column] = Gross Margin then 1, else if [column]=Expenses then 2..."

Then you can set your "Sort By" column in Desktop for the original column to be this "sort" column.

[NipponSahore]

The order is usually alphabetically. 

You can add a prefix to the name to order it in the order you like 

1. Gross Margin

2. Expenses

3. Amortization

4. Interest

5. Taxes

[mjc543]

After messing around with DAX and trying to create a sort index, but running into circular dependency errors, I decided to use this method instead. Simple and effective; only adds 3 extra characters, which I can live with. Thanks for the tip!

[cmartinez]

But if you have more than then items the first is set wuth the eleven 😞

[CKHarwood]

For tens of items, prefix each item with a two-digit number: 01, 02, 03, . . . , 10, 11, 12, . . .

[cmartinez]

But if you have more than then items the first is set wuth the eleven 😞