Sort a column with repeated values based on another column

[Anonymous]

Hi there.

For my requirement, I've got a specific layout for a report. To simplify, the series of Categories should present the Areas in a particular order (financial information).

Every Category will be present on a different Page on Power BI. However, as you can see, some areas belong to multiple Categories. Because of this, I'm getting an error message if I try to order this column by an index, and I can't modify the name of the area.

Is it possible to specify on a cross table that I do not need it to perform any alphabetic order?

I've looked for a possible answer, but so far I have not found any solution to this.

Regards.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I have a trick to avoid this error.

You could import the data whose category is "A" at first. Then import other data and you will have two queries.

Sort your first table based on another column, then append these two tables ( not as new ).