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
5 years ago

Workaround in Power BI Desktop:  Clear the sort by removing the field it is sorting on.

 

1) Introduce a new field into the visualization

2) Choose to sort on the new field

3) Choose ascending or decending sort option (I need to do this to make sure that it was sorting on my new field)

4) Delete the new field from the visualization -- thus clearing out the sort on the visualization

 

Good Luck!