Sort by other column in Table view not working.

[tomas12344]

HI All
Just wondering if you have the same problem with the Sort by (other column) feature in PBI:
Have a table like this 

When in Table view I want to sort the Column1 by Table(2).Column2, I get error 

But when I do the same in the Report view, it works as expected. 
After setting this sort in Report view and going back to Table view, it looks like that it is set correctly (of course cannot change, because get again the error).
There is a tutorial, that describe, it should work in Table view as well https://www.youtube.com/watch?v=3qOH2i4iLcU. 
Do you have the same experience?

[Anonymous · Accepted solution]

Hi,

Thanks for the solution rajendraongole1 and Muhammad_Ahmed offered, and i want to offer some more information for user to refer to.

hello @tomas12344 , you can consider to create a new table.

Table 2 = SUMMARIZE('Table',[Column1],[Table(2).Column2])

In new table click the column1 and sort by the table(2).Column2

Then create a 1:n relationship between tables.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It can work.

[Muhammad_Ahmed]

Hi,
It is working fine for me.

[rajendraongole1]

Hi @tomas12344 - "Sort by Column" works in the Report view and the Data view of Power BI. It is best to apply your sorting in the Report view, where it functions correctly, and avoid making changes in the Data view to prevent errors.

if possible can you please share the sample data problematic one will check this and update you.

[tomas12344]

HI @rajendraongole1

Column1 Column2 Table (2).Column2
b 2454 1
b 2235 1
b 131 1
c 524 2
c 542 2
c 645 2
c 426 2
a 234 3
a 255 3

[rajendraongole1]

Hi @tomas12344 - As I mentioned above, the column table(2).Column2 is sorted already, we no need to sort it again on report or table view. you can see it is already highlighted

hope it works at your end. i am currently using August release of power bi desktop version.

[tomas12344]

@rajendraongole1 Can you read again my post to see what I'm asking for? Whay I would like to sort the column table(2).Column2 by the column table(2).Column2 (with this function?)?

[rajendraongole1]

Hi @tomas12344 - I have checked what you mentioned, 

"When in Table view I want to sort the Column1 by Table(2).Column2, I get error "

I am able to sort the same column1 in data view or report view too. thats why the same attached the snapshot for your reference.

Sort the column1 by Table(2).column2 I didnt get any error.

Hope it helps you and please check and still any, please elborate and share the pbix file in drive that you are using and let know

[tomas12344]

@rajendraongole1 I still dont know what are you doing. Your screen shot are probably wrong, you probably swapped them. 
Just to be sure, do you know this function Sort by (other column)? In my original post is of course a video how to use it, and what I want to do.