Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to sort date hierarchy column in matrix chart

Hi 

I have a Date Hierarchy in columns in Matrix table but I am not able to sort it , Dec1,2 should go at the end of the table not at the begining of the table. Date Hierarchy has Year,Month,Day,Hour.

Please help.

 

Thanks,

Rajesh

 

Need Help

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous,

     

    Have you sorted the date column according to other columns?

    You can refer to this post .

    If the problem persists, Could you please share sample data of your original table? (Please mask any sensitive data before uploading.)

     

    Best Regards,

    Liang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quick

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Is this problem sloved?
    If not, please let me know.

     

    Best Regards,

    Liang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

     

    Sort the date column in ascending order. (Refer attached screen shot)

     

    Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!