Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cancel sorting in table

Hi, how it possible cancel ordered column in table in Power BI? Once I sort the column, I can't cancel it anymore.   Thank you  
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    If you refer to sort for dataset, After you sort the column, then you can cancel the sort.

     

    If you refer to sort in table visual, you need to click on "sort" again.

     

     

     

    I use the lastest version.

    Version: 2.60.5169.3201 64-bit (July 2018)

     

    Best Regards

    Maggie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you.

But when it is the only one solution for removing sorting it isn't user-friendly.

It should look like this: one clik sorting asc, second desc and third remove sorting.

80210335's avatar
80210335
Frequent Visitor
8 months ago

I agree, one click ASC, two clicks is DESC, three is return to none. This is bad UX/UI. Most other applications do it that way. You can use the back arrow if you haven't gone too far down the rabbit hole to return the table to a pre-sorted state as well.