In Power BI, how do I sort slicer values (other than by name)?

Question

I have a slicer with 4 values {daily, biweekly, monthly, annually}, and I want to sort them in that specific, custom order (that IS NOT alphabetical). My data query has them sorted correctly (by a numbered sort column), and they're sorted correctly in the table display. However the sort order does not transfer to the slicer itself where they are displayed alphabetically.

Answer 1

This is really the same answer as the one from Alexis Olson, but with some more elaboration. The tricky part is that when viewing your table that holds the columns for the slicer, you must highlight the column that holds the values displayed in the slicer, but then go to the "Sort By Column" and select the OTHER column that you want to sort by. Step by Step

1. Go to Data tab on the left ribbon
2. Select the table you're using in the slicer on the table list on the right
3. Click on the header for the column that is DISPLAYED in the slicer
4. Click on "Sort by column" in the toolbar
5. Choose the other column, the one that you want to sort by

Answer 2

The key here is to use Sort by Column under the modeling tab where you sort by a column that defines the order.

Once that is set, your slicer should automatically sort how you want.