Forum Discussion

benidoink's avatar
benidoink
Frequent Visitor
4 years ago
Solved

Slicer order by Month

Hi Guys,

Is there a way to sort the slicer by month order like (January to December)? See below the screenshot of the slicer. 
The only option I saw was sort descending and sort ascending.
Or you can give me a suggestion of what I will use in case this will not work. What I wanted is a monthly button that when I select the dashboard will refresh based on the data source.



Thank you.

 

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi benidoink ,

     

    Create column with below code and sort the month column with the newly create column.

     

    Month_num = MONTH([Date])

     

     

     

    Thanks,

    Samarth

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi benidoink ,

     

    Create column with below code and sort the month column with the newly create column.

     

    Month_num = MONTH([Date])

     

     

     

    Thanks,

    Samarth

  • benidoink's avatar
    benidoink
    Frequent Visitor
    4 years ago

    Hi Samarth_18 ,

    Thank you for this sample I will use this. 
    But my main concern is the sorting of Months in the Slider. as I mentioned above. I wanted to sort the slicer Starting from January, February, March, April, May..... to December. 




    Thank you