reshuffle your columns

[Anonymous]

Hello community members, 

Perhaps a strange question, but is it in the desktop version possible to reshuffle your columns? Originally I had about 10 columns, but I added another 25 calculated columns. In Power Query, it is possible to reshuffle your original columns in another order, but is this also possible in the desktop version?

Hope to hear soon from you!

Best regards, Sander

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Currently this is not supported in Power BI Desktop. You could vote for below ideas about this feature. Thank you. 

Microsoft Idea  · Reorder columns in Data Preview

Microsoft Idea  · Allow the Reordering of calculated columns

Microsoft Idea  · COLUMN SWITCHING IN DATA TAB (OUTSIDE OF THE POWER QUERY)

Microsoft Idea  · Reorder Columns in Data Model

Microsoft Idea  · Reordering columns in the Data view

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[selimovd]

Hey @Anonymous ,

in Power BI that's not possible.

You can change the order in Power Query. If you calculate a table in Power BI and add columns later, they will appear at the end. If you want to change the order, change it in the forumla, remove the table and create it again. Then the order fits to the one in your code.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[amitchandak]

@Anonymous , I think that is possible in power query only