- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-25-2024 01:39 PM | |||
04-04-2024 06:20 AM | |||
11-01-2017 08:08 AM | |||
08-01-2024 08:00 PM | |||
09-15-2024 08:24 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |