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.
78 Comments
- ChristianDiscerAdvocate IThe task pane displays database fields in alphabetical order. Please allow the field list to be displayed in original, or database defined order.
- pbiideas1New MemberFound a related idea: "Display field names in database, not alpha, order"
- aleksandarkostaNew Membercan you order variables in fields section as imported from Excel
- steve_gorhamNew MemberCurrently if you set the "Default Field Set" field order in an SSAS Tabular model, it is not utilized by Power BI in the Fields pane. It still only sorts alphabetically.
- fbcideas_migusrNew MemberWhen looking at the tables in the Relationships window - and to make new relationships - it would really help to show the fields in alphabetical order. It feels like I'm always going on a scavenger hunt when I'm trying to find a field because I have to scroll thru the entire list looking for it. This can be challenging and time consuming, especially with large tables. Thanks!
- vincentvanasperNew MemberWould really like this to be supported.
- jonathan_marti6New MemberGreat Idea, and possibly to group fields together as well?
- martint1New MemberSSAS Tabular has a "Table Detail Position" described as "...field ordering that define the default field set when visualizing this table in certain client tools". Surprisingly, Power BI is not such a "client tool". Frankly, quite odd, when you think of how closely related Power BI and SSAS tabular are underneath.
- martint1New MemberCross post https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18355429-use-field-order-as-ordered-in-source-query
- mark-allen-perrNew MemberI agree that the 'default' order for "Fields" should be whatever it is in the source. There is a reason the source has the fields in a specific order, so changing it means the 'structure view' to the user has changed. Please keep the order the same by default, and then (maybe) allow changes to be modified to 'sorted A-Z', etc. Many thanks.
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v5 hours agoCommunity ChampionNew612Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v12 hours agoCommunity ChampionNew17Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019716 hours agoFrequent VisitorNew6Views0likes0Comments