Forum Discussion

sanoraya's avatar
sanoraya
Frequent Visitor
10 years ago
Solved

Sorting the Slicer

Hi,  I am struggling with how to sort the slilcer the way I need:    I have a table like this:  Number Month 1           Jan 2           Feb.  3           March etc...    The slicer only al...
Need Help
Tips and Tricks
  • GilesWalker's avatar
    GilesWalker
    10 years ago

    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

  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi sanoraya,

     

       try following my post here.

    Let me know if it works.

     

    #I'M Not An Expert#

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

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

jb1t's avatar
jb1t
Advocate I
9 years ago

Is there a way to sort in descending order? I have 3 columns and ID, Name, and Count. I want to sort by the largest count first.