Forum Discussion
Sorting the Slicer
sanoraya - To order your months by a number range I go to the data tab in Power BI desktop:
In the ribbon you will see the Sort By Column button. Select the column you are interested in first (in my picture it would be Months), then click the Sort By Columns button.
Now you need to have a column which lists the months in the numeric order you want. For example, January will always show up as 1. In the sort by column button you will then need to click the appropriate column containing the month numbers.
This will then sort your slicer the way you want.
Thanks,
Giles
The solution is far easier than I thought.
Steps
- In the "Fields" pane, click on the field that is being dispalyed.
- On the "Modeling" tab, click "Sort By Column".
- Chose the column that you want to sort the displayed field by.
- Viola
This option no longer exists on my Modeling tab. Has it been moved?
The option is right there as usual:
In this example, I sorted my reports for the Superintendent Column, which is sorted by the Order Column so, is not get sorted alphabetically but by the numbers set in the Order Column
Ahh I see what I did wrong. I was clicking on the field within the hierarchy, instead of the calculated column itself. I found it, thanks!