Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Sort Order for a Measure

I have the following measure which returns the screenshot of data below when applied to a matrix - essentially the date with a little calculation of how many days old the note is.      StatusNote...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    I meant you can FORMAT the date in your measure.

     

    FORMAT(SELECTEDVALUE(...), "yyyy/MM/dd")

     

    Pat

Anonymous's avatar
Anonymous
Not applicable
3 years ago

amitchandak I converted my measure to a calculated column so that I could use the method you described. I'm still having a problem though. In data view, you can see that the calculated column is being sorted by ProjectStatusNoteDate (which is marked as a date field) and the sort is in the correct order.

 

 

 

However, when I go to my visual it is still out of order. In descending order, we see 5/5, 5/3, 5/2, then 5/11, 5/10, 4/29 and so on.

 

 

I've tried resorting the visual many times and continue to get the same result. Is there anything else I can try?