Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Slicer Sorting

Hello All,    Good Morning. I am having an issue of sorting the dates in my slicers. Please refer the below screenshot for understanding what kind of sorting is needed for me.   I wrote a conditio...
Need Help
Show and Tell
Tips and Tricks
  • affan's avatar
    affan
    7 years ago

    Hi Anonymous

     

    You can add a calculated column in your date dimensions table as below.

     

    YearMonthNum = Time_Dimension[Date].[Year]*100 +  Time_Dimension[Date].[MonthNo]

     

    Then you can go to Modeling and sort the FiscalMonth Year on this new column.

     

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

affan's avatar
affan
Solution Sage
7 years ago

Hi Anonymous

 

You can add a calculated column in your date dimensions table as below.

 

YearMonthNum = Time_Dimension[Date].[Year]*100 +  Time_Dimension[Date].[MonthNo]

 

Then you can go to Modeling and sort the FiscalMonth Year on this new column.

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Fantastic!!! Thank you very much for your timely help. KUDOS.