Forum Discussion
Ascending order
Hello,
I dont want the data sorted as Power BI does. I want the data in the same way they are in the table. Any ideas about how to remove the order ?
Table
Power BI
Thank you
Hi AudreyRene ,
Regarding your question, you can use the 'Sort by column' button.
Sort one column by another column in Power BI - Power BI | Microsoft Learn
The Table data is shown below:
Please follow these steps:
1.Creating an index column in 'Power query'.
2.Click the 'Sort by column' button.
3.Final output
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Hi AudreyRene ,
Regarding your question, you can use the 'Sort by column' button.
Sort one column by another column in Power BI - Power BI | Microsoft Learn
The Table data is shown below:
Please follow these steps:
1.Creating an index column in 'Power query'.
2.Click the 'Sort by column' button.
3.Final output
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello,
The solution works, but how can i hide the column ? I don't want the colum index to be part of my visual
Thank you !
Hi AudreyRene ,
If you have used 'Sort by column', you can remove index column. As in the picture I provided, I did not add the index column in the table visual.
