Reply
AlB Member
Member
Posts: 200
Registered: ‎11-12-2018

Possible to rearrange columns in a table?

[ Edited ]

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 

Super User
Posts: 9,477
Registered: ‎07-11-2015

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.


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

Proud to be a Datanaut!


Highlighted
AlB Member
Member
Posts: 200
Registered: ‎11-12-2018

Re: Possible to rearrange columns in a table?

[ Edited ]

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
Posts: 9,477
Registered: ‎07-11-2015

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


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

Proud to be a Datanaut!


AlB Member
Member
Posts: 200
Registered: ‎11-12-2018

Re: Possible to rearrange columns in a table?

Sounds like a dream solution Smiley Very Happy