Forum Discussion
Need help sorting a slicer with months
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.
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
2 Replies
- audreygerred
Super User
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
- 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
