Forum Discussion
Sort by other column in Table view not working.
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?
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.
8 Replies
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.
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 3Hi 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.
Hi,
It is working fine for me.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.
