Sorting from most recent to least recent

[jcastr02]

I am trying to show the most recent comments on the top of the visual.  When I sort by column - I get error message below.  Please see the 30 day tab on BI file.  I have tried also adding index column and that doesn't work.  It seems it is related to repeating values such as N/A.   I am trying to correct visual that shows "additional support needed" on the 30 day page. 

 https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=tXy0lr 

[v-frfei-msft]

Hi @jcastr02 ,

Please insert an index column in the table '30 Day - Addtional Support Needed' in power query and make the column 'What can we do to provide additional support to improve your experience?' sorted by it.

We can also create a calculated column and add it together with column 'What can we do to provide additional support to improve your experience?' to visual to work around.

index = CALCULATE(COUNTROWS('30 Day - Addtional Support Needed'),FILTER('30 Day - Addtional Support Needed','30 Day - Addtional Support Needed'[Start Time]<= EARLIER('30 Day - Addtional Support Needed'[Start Time])))

Alternatively, We can use a measure to work it out.

Measure 2 = var maxstarttime = CALCULATE(MAX('30 Day - Addtional Support Needed'[Start Time]),ALLSELECTED('30 Day - Addtional Support Needed'))
return
CALCULATE(MAX('30 Day - Addtional Support Needed'[What can we do to provide additional support to improve your experience?]),FILTER('30 Day - Addtional Support Needed','30 Day - Addtional Support Needed'[Start Time]=maxstarttime))

For more details, please check the pbix as attached.

[jcastr02]

Hello @v-frfei-msft   when I try to add the measure , visual look like this..

I can't use the column measure as I don't want to show the index column on the visual.  when i try to shrink it , the word wrap still makes all boxes too big....