Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Question about sorting

Hi, this is a general question. I have built a report based on a excel file. In this excel file, i have a column called "Trades". In the excel file, these trades (column) are in a specific ord...

HotChilli
4 years ago
https://docs.microsoft.com/en-us/power-query/add-index-column#:~:text=%20In%20this%20article%20%201%20Add%20an,the%20final...%205%20Clean%20the%20table%20See%20More.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#:~:text=1%20Sort%20by%20column%20in%20Power%20BI%20Desktop,Sort%20by%20Column%20button.%20...%206%20Next%20steps

HotChilli

Community Champion

4 years ago

An Excel file has a specific order (based on row number). PowerBi doesn't have a built-in order for data. You can use alphabetic order in visuals OR make your own order using an Index column and 'sort by column' feature.

For sub-trades, you would have to add a column which indicates the parent. You can do this in Power Query

Anonymous

Not applicable

4 years ago

thank you for your prompt response..... i dont want them to be in alphabetical order so im very interested when you say "make your own order using an Index column and 'sort by column' feature." Can you explain how to do this from the excel file? im new.... 🙂

Forum Discussion

Question about sorting

Related content

Bookmark questions

Sorting

Architecture question and brainstorming

Table Sort , sort order , comparer

Unpivot Question