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

BratKat 
No, just keep the original YearMonth column in the x-axis and use the "sort by column" option to sort the YearMonth column by the YearMonth column number. Go the table view, select the YearMonth column then from the "sort by column" option, select the YearMonthNumber

 

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

Already did that, its usually when I move the Slicer that it stops sorting correcty, using the "between" option in the slicer.