Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hierarchical slicer Date Sort

Hello Community - I have a hierarchical slicer on my report from my calendar table that should display 'Week Ending' and then underneath it, all the individual days.     I cannot get the child ite...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hello, @amatulis

    As mentioned @amitchandak , you can create a sort column.

    Rank = RANKX('Calendar','Calendar'[Date],,DESC,Dense)

    Next, create a "New Date" column:

    New Date = 'Calendar'[Date]

    Have the new "date column" sort by column "Rank"

    42.png

    The result will be displayed as shown below:

    43.png

    See the attachment for more details.

    Best regards
    Community Support Team _ Eason
    If this post helps,then consider Accepting it as the solution to help other members find it faster.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have sorted every which way and they work properly for ascending but not descending.  

 

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hello, @amatulis

As mentioned @amitchandak , you can create a sort column.

Rank = RANKX('Calendar','Calendar'[Date],,DESC,Dense)

Next, create a "New Date" column:

New Date = 'Calendar'[Date]

Have the new "date column" sort by column "Rank"

42.png

The result will be displayed as shown below:

43.png

See the attachment for more details.

Best regards
Community Support Team _ Eason
If this post helps,then consider Accepting it as the solution to help other members find it faster.