Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Order column between power query and power bi

Hi,

 

In Power Query, my last step is to put my column in a specific order, below the order of my 5 last columns.

 

But when i close and apply, then i update my power bi file, in my data view the modification of columns order did not change. My columns "Conformité livraison" and "Conformité quantité" are reversed and my column "Ecart livraison" is is on the left in my table.

 

If you have any solution it would be nice.

Thanks in advance.

 

Best regards, Romain.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Depending on the information you have provided. Unfortunately, this is by design. Power BI is now unable to achieve what you need. You can submit an idea for it at Home (microsoft.com)

     

    There is a workaround to consider: You can change the order of the columns in the report view instead of the table view by dragging and dropping the column headers:

     

    Best Regards,

    Ada Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.