Forum Discussion
Sort by column in Data View - remove it
- 1 year ago
Hi pigsinblankets -To reset the "Sort by column" setting, you can select the column you wish to revert and then choose another column temporarily as the sort column, before going back to the default sort. If you're struggling with the visual, ensure the column header isn't showing an active sort icon (the little arrow). If all else fails, try reopening Power BI Desktop or your PBIX file.
If you created a custom sort column (e.g., for sorting months by fiscal order), simply remove the column by deleting it or reverting its function in the data model.
In some cases, you might not see a clear "None" option. You can remove the sort by simply selecting the column itself as the "Sort by column" again, or by choosing a different column and then going back to the original column.
Hope the above information helps
You can check the applied steps on query setting window