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 wou...
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. 

     

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. 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    :smileyhappy:

     

    Best Regards
    Maggie