Ascending order

[AudreyRene]

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

[v-zhouwen-msft · Accepted solution]

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.

[AudreyRene]

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 !

[v-zhouwen-msft]

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.

[AudreyRene]

Hello,

I have used Sort by column. Still, if i remove the column Index from my visual, the visual doesnt work

[v-zhouwen-msft]

Hi @AudreyRene ,

Based on your picture, it seems that you used 'sort by Column' for the 'Index' column.

So after deleting the 'Index' column the sorting will become invalid.

Please select the column you want to sort.

If you still have problems, can you share the .pbix file without the sensitive data?

[AudreyRene]

Hello,

Yes i want the data to be sort with the Index Column but i dont want the column in my visual.  How can i share my .pbix file ? 

[v-zhouwen-msft]

Hi @AudreyRene ,

You could upload the file to OneDrive / Google Drive / DropBox and share the link here.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

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.

[AudreyRene]

Hello,

I find a way to remove the column index and i accept the solution. 

Thank you a lot for your time !