Ian Bennett on 17 Feb 2017 08:50:54
At least as an option, allow fields to be ordered the same as the source query rather than alphabetical. This way they can be put in a logical and consistent order.
Obviously, a workaround is to prefix each column name with a number but this is clunky, unattractive and a pain if the columns change often.
- Comments (78)
RE: Customize fields list ordering
Good information, thankssehackear.top
RE: Customize fields list ordering
ThanksHackear Instagram Hackear WhatsApp Hackear Facebook
RE: Customize fields list ordering
I don't understand why this basic feature hasn't been implemented, while in Power Pivot in Excel, fields appear in the same order than the source.
RE: Customize fields list ordering
Surprisingly this is not done. Missing functionality, especially if we are looking at Microsoft Fabric seriously.
RE: Customize fields list ordering
This is very basic requirement for a reporting tool. This feature will help to bypass lot of manual works required to get columns in proper order.
RE: Customize fields list ordering
First thing I noticed after trying Power BI today. The default sort should match the order of the original data source to avoid confusing people.
RE: Customize fields list ordering
Any sort of usability testing would have shown that this is a must have, not an afterthought
RE: Customize fields list ordering
5 years and this has not yet made it to the top of changes? Please ask your developer friends if they agree this would be really useful - and if so ask them to vote!
RE: Customize fields list ordering
I've just wasted two days cleaning up a massive Excel file and just now discovered that Power BI sorts columns in alphabetical order in the Fields Pane. The data I was trying to visualize are survey responses, so the column order in the original file is crucial. Well, at least I was able to get a definitive proof-of-concept result: I can't use Power BI to create dashboards from survey data.