ML with circles

Mearns Learns

Sort by a column not used in Power BI visual

This steps through how to sort a column by another column which is not used in a Power BI visual.

This is a must have feature for time intelligence analysis. If dates have been formatted as text, Apr-2022 will be appear before Jan-2022.

Click on the *Data icon in the left menu.

Sort by a column Sort by a column

Select the table to be sorted and click on the column to be sorted.

Sort by a column Sort by a column

Navigate to the Column tools tab and click om the Sort by column icon.
Select the surrogate column to be used for sorting.

Sort by a column Sort by a column

The columns must both have the same format.
In example screenshots the YYYY-MM column is used to sort the MMM-YYYY column.
Both columns are text format.
When the column is used in a visual it will be sorted by the surrogate column.