cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Possible to rearrange columns in a table?

Hi all,

 

Two questions:

 

1. Is it possible to move one column to another place in a table in Power BI? Imagine you have a table with many columns and you want to add a new calculated column. This gets added at the end of the table. It would be nice if it can be placed somewhere else, for example next to the columns used for calculating the new column.

Is that possible at all?

 

2. Is there any way to mark/highlight/color the calculated columns to that they can be readily differentiated from the original data columns (imported)

 

Thanks very much 

4 REPLIES 4
Super User
Super User

Re: Possible to rearrange columns in a table?

At the present time I am not aware of solution to either of those. For the first one, you could potentially create a new table based on the original table using SELECTCOLUMNS and put them in the order you want.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Super User

Re: Possible to rearrange columns in a table?

Thanks @Greg_Deckler

As to using SELECTCOLUMNS, if the table is large, with many columns, it would be quite time consuming wouldn't it?

Super User
Super User

Re: Possible to rearrange columns in a table?

Oh yes, it's a terrible idea quite honestly, but technically a way to do it if you don't mind duplicating all of your data, increasing your data load times and creating a maintenance nightmare. Smiley Happy


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Super User

Re: Possible to rearrange columns in a table?

Sounds like a dream solution Smiley Very Happy

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 132 members 1,780 guests
Please welcome our newest community members: