Forum Discussion
reshuffle your columns
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
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.
3 Replies
Anonymous , I think that is possible in power query only
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi 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.
