How to clear all sorts in all table columns?

[croberts21]

I have PBI v October 2022. 

I have a table viz with some test data. Some columns are dates, some are strings, some are numbers. I want to clear all sorts from all columns. But when I click on a column header the only options are sort ascending and sort descending. "No sort" is not an option. 

Thank you.

EDIT: So I searched a bit more and found this solution:

1. Sort by the last column only.
2. Delete the column from the table.
3. Re-add the column, now the column will be unsorted.

[croberts21 · Accepted solution]

I added my solution to the original question.

[Anonymous]

HI @croberts21 ,

AFAIK, current t seem not include reset sorting features.

In my opinion, I'd like to suggest you create a bookmark to saving the default sorting effect and binding it to the button. Then you can use this 'reset' button to simply reset these effects.

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng