Need help sorting a slicer with months

[U156531]

I need help sorting these months in the slicer below. The column in the slicer is MTDwithcur. I'm trying to use the Sorting column in the table below. Thanks.

[jdbuchanan71]

Your sorting measure is not returning what you are wanting.

Try it like this.

Sorting =
VAR DateYear = YEAR([Date])
VAR DateMonth = MONTH([Date])
RETURN DateYear * 100 + DateMonth

[audreygerred · Accepted solution]

Hello! In the data pane, select the field that needs to be sorted (in your case MTDwithcur) and then in the ribbon along the top find the Column Tools tab and then select Sort by column in that and select the column to want to sort by (which for you is Sorting). This will make MTDwithcur sort by Sorting.

Sort one column by another column in Power BI - Power BI | Microsoft Learn