Forum Discussion
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 order, but when i add a table to the Power BI, it seems to want to alphabetically set this column up. Why? And specifically cant i have the exact same order as was in the spreadsheet for Trades? If so, please tell me how to "override" the sorting.
also.... some of these Trades are subs. See picture. Is there a way to keep this? How, please tell me how i can accomplish this.
thank you in advance.
3 Replies
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