sorting comments from newest to oldest - Matrix

[jcastr02]

I have a matrix with open text comments from a survey.. I am trying to organize them from newest to oldest.  I tried to use "sort column by' Completion date but it's giving me an error.  One column has dates, the other has texts?  However, getting the below error message, what can be done?   In query editor, I have the date set to date/time format, and the comments to text.

[v-eachen-msft]

Hi @jcastr02 ,

You could check if your tables have relationships to affect sorting feature.

You could also take a look at the following blog about creating a custom sort order table to achieve customer sort order:

Custom Sorting in Power BI

[amitchandak]

Try to create a dense rank column on date and then try to use that column to sort comment

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures