Forum Discussion

AudreyRene's avatar
AudreyRene
Helper I
2 years ago
Solved

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 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
AudreyRene
Helper I
2 years ago

Hello,

 

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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    AudreyRene
    Helper I
    2 years ago

    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 ? 

      • AudreyRene's avatar
        AudreyRene
        Helper I
        2 years ago

        Hello,

         

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

         

        Thank you a lot for your time !