Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sort Month Year Slicer Descending

Hi All, I have a 1-to-many join on a month table that filters my other 2 tables on month that contain my data. I'm trying to do a sort by column on my month table, but it's not changing the order ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

    As you said, you have a MonthReverse Column present, so I assumed some data for testing:


    You must make sure that the type of your MonthReverse Column is whole number:

     


    Then drag the Month field into Slicer's Fields panel:

     


    Then click on the Month field, find the Sort by column at the top and select the MonthReverse Column:

     


    This gives you the freedom to choose whether your Month column is ascending or descending based on the MonthReverse Column:

     

     

    I've attached the pbix file for this little example below, hope it helps.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.