Forum Discussion

BratKat's avatar
BratKat
Microsoft 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.  

BratKat's avatar
BratKat
Microsoft Employee
3 years ago

When the column is used in a column graph and month days are displayed, these are not in correct order even if sorted correctly in the graph, need to add sorting or format to the measure\column code above so it stays sorted. A A slicer is used to select days of the month and the measure\column is used in the graph as the X-axis.

 

 

 

 

 

The days start out correctly then is out of order. 

Thank you 

BratKat's avatar
BratKat
Microsoft Employee
3 years ago

Additional info: 

We already have a column that has Dates in our data set, Team Date 01 that has the dates of each item in our dataset. 

This is used in the X-axis 

MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Items'[Team Date 01])
and Team Date 01 is used in a Slicer.