Forum Discussion

Sdutta's avatar
Sdutta
Regular Visitor
8 years ago
Solved

Sorting a slicer

Hello all,

 

In my source table I got 2 date columns.

 

PeriodCode = 201601, 201602, 201603 ....201612

PeriodName = Oct2016, Nov2016, Dec2016....Sep2017

 

Where 201601 corresponds to Oct2016 as that's when our company financial year starts.

 

In the slicer, I want to show PeriodName but sort it by PeriodCode rather than it sorting itself alphabetically. How can I achieve this please?

 

Thanks much.

  • MFelix's avatar
    MFelix
    8 years ago

    Hi Sdutta,

     

    You should sort your column by the PeriodCode and then you will get the information as you want.

     

     

    Regards,

    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Sdutta,

     

    You should sort your column by the PeriodCode and then you will get the information as you want.

     

     

    Regards,

    MFelix

    • Sdutta's avatar
      Sdutta
      Regular Visitor
      8 years ago

      Absolutely perfect, thank you so much.

       

      Having worked in SSRS for years, I am just a bit slow in getting used to Power BI way of dealing with these things.

       

       

      Regards

      SDutta