cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rsakamuri Frequent Visitor
Frequent Visitor

how to change the table or column order in data set?

We wanted to change the order of the table or column to custom order in Power BI data set? Please let me know if we have any work around for this. Thanks in Advance.
1 ACCEPTED SOLUTION

Accepted Solutions
tarunsingla Established Member
Established Member

Re: how to change the table or column order in data set?

Column sorting in query editor is possible and easy, just drag and drop columns to desired spots.

 

But that sort order will not be applied to the report view. The tables are alphabetically sorted in the report view, and the table columns are sorted alphabetically too.

 

By renaming tables or columns (prefix with some index or alphabet), you would be able to achieve the desired sorting. But thats a workaround.

View solution in original post

4 REPLIES 4
tarunsingla Established Member
Established Member

Re: how to change the table or column order in data set?

rsakamuri Frequent Visitor
Frequent Visitor

Re: how to change the table or column order in data set?

Thanks for your reply.

 

I am looking for Table/Column order change in data set, NOT the SORT Order in report.

I want to move the col3 to FIRST position in the table3. As well as Table4 to 1st position in the tables list.

 

  1. Table1
  2. Table2 
  3. Table3
    1. col1
    2. col2
    3. col3
  4. Table4

 

Thanks in Advance.


 

tarunsingla Established Member
Established Member

Re: how to change the table or column order in data set?

Column sorting in query editor is possible and easy, just drag and drop columns to desired spots.

 

But that sort order will not be applied to the report view. The tables are alphabetically sorted in the report view, and the table columns are sorted alphabetically too.

 

By renaming tables or columns (prefix with some index or alphabet), you would be able to achieve the desired sorting. But thats a workaround.

View solution in original post

rsakamuri Frequent Visitor
Frequent Visitor

Re: how to change the table or column order in data set?

Thanks Tarun. If we have any other work around other than Prefixing with some string, that will be great.

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors