Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Order of columns in Query Editor and in Data Model are not the same

    Top Contributor
    Posted Oct 10, 2020 11:59 AM
    Hi,
    How can we move a column in the Data view. In the Query Editor, I placed the ID column on the very left in my table. Despite several Apply , in the Data Model, Data view this column is not at the same place. I tried to move the column with the mouse, with no avail.
    Thanks for your help

    ------------------------------
    Gérard Ducouret
    ------------------------------


  • 2.  RE: Order of columns in Query Editor and in Data Model are not the same

    Top Contributor
    Posted Oct 10, 2020 10:17 PM
    Why do you care about the column sort order? For aesthetic reasons?  The Vertipaq engine does not care about that at all.

    ------------------------------
    Lutz
    ------------------------------



  • 3.  RE: Order of columns in Query Editor and in Data Model are not the same

    Bronze Contributor
    Posted Oct 12, 2020 10:29 AM
    The only time I've seen the order of columns matter is if you're trying to union all the columns in 2 tables using Dax without having to list all of them.
    Unfortunately, I haven't seen a good way to do it.  The order in the query editor is actually the order they are added.  It won't matter if you reorder them in the query editor.
    If that is what you're trying to do, you'll have to use the UNION function and list the columns in the order you want.
    I haven't seen the column order matter for any other reason.


    ------------------------------
    Wallo Atkinson
    Green Bay
    ------------------------------



  • 4.  RE: Order of columns in Query Editor and in Data Model are not the same

    Posted Oct 28, 2022 01:23 PM
    I know how it feels!!

    Solution: (1) Power BI Tips & Tricks : A workaround to re-order columns in Data View - YouTube
    Careful with relationships/data loss

    ------------------------------
    Marcos Ramírez
    ------------------------------