Forum Discussion

subhendude's avatar
subhendude
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Sorting Date column in matrix visual

I've a date slicer and a matrix visual to display the data with date as columns. PFA snapshot I would like to configure the matrix visual in such a way that it always sort the date data in the...
Need Help
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi

    I think you need an extra column as index column (Desc) to sort your Date by this extra column

    Use RANKX function in  new calculate column like below:

     

    index = RANKX(table,'Date,,Desc)

     

    then sort your Date by column Index

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
4 years ago

Hi

I think you need an extra column as index column (Desc) to sort your Date by this extra column

Use RANKX function in  new calculate column like below:

 

index = RANKX(table,'Date,,Desc)

 

then sort your Date by column Index