Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort Date Hierarchy

How do you sort the month in a date hiearchy?

I have a month abbreviation sort column. My table is sorted by DateKey. 

 

It would be nice to set MonthAbbr sort by MonthNumberOfYear just like I would in SSAS. 

I don't want to mess up my DateKey Sort as the default on the table. 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I found the answer. In the modeling, click the column and use the Sort By Column button and select the sorting columns. 

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I also want to be able to do this:

    Months by Year. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Is there a way to have 2 hierarchies sort in different ways. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I found the answer. In the modeling, click the column and use the Sort By Column button and select the sorting columns.