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
Deployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v11 minutes agoCommunity ChampionNew6KViews137likes17CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles45 minutes agoRegular VisitorNew212Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi1 hour agoRegular VisitorNew2Views0likes0CommentsDeployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels9 hours agoAdvocate IINew1View1like0Comments