Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Sort column not exposed in Transform data

Have a column measure that is not exposed in Transform, is there and FORMAT command I can use in this to make sure it sorts correctly, tried other suggustions using Tooltips but those do not work. T...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi BratKat 

    You ca create a sort by column 

    MonthDayNumber =
    VALUE (
    MONTH ( 'Work Items'[Team Date 01] ) & DAY ( 'Work Items'[Team Date 01] )
    )

    Select the MonthDay column, go to column format - sort by column and select the MonthDayNumber column. 

  • BratKat's avatar
    BratKat
    3 years ago

    The MonthDayNumberYear measure or column.  

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi BratKat 

You ca create a sort by column 

MonthDayNumber =
VALUE (
MONTH ( 'Work Items'[Team Date 01] ) & DAY ( 'Work Items'[Team Date 01] )
)

Select the MonthDay column, go to column format - sort by column and select the MonthDayNumber column. 

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Tried this however returned some strange results, slicer not returning correct dates..?

 

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    BratKat 

    Which column are you placing in x-axis?

    • BratKat's avatar
      BratKat
      Icon for Microsoft Employee rankMicrosoft Employee
      3 years ago

      The MonthDayNumberYear measure or column.  

      • BratKat's avatar
        BratKat
        Icon for Microsoft Employee rankMicrosoft Employee
        3 years ago

        Got this working, forgot to add "Year" in the data item, so now it sorts correctly, thank you.