Forum Discussion
Sorting by Index
I see, didnt realize that there would be the same date values aswell ofcourse. I've taken a look at your PBI file and i would suggest creating a new table from the one used with only the Comments and date and/or index. And then filter out the Blanks.
BTW. The CTRL+Click on buttons is only in the desktop version. When published to service you no longer need to use CTRL. 🙂
Anonymous I tried to sort the comments by Completion Time - On the visual I have a matrix box with all the comments and I'd like to sort from newest to oldest, but when I try to sort the column, I get the same error message
I see, didnt realize that there would be the same date values aswell ofcourse. I've taken a look at your PBI file and i would suggest creating a new table from the one used with only the Comments and date and/or index. And then filter out the Blanks.
BTW. The CTRL+Click on buttons is only in the desktop version. When published to service you no longer need to use CTRL. 🙂
Thank you SO much this worked!!! and thank you for the recommendations on the buttons!! 🙂 Anonymous
Anonymous It looks like some of my tables worked, but others didn't when I followed process. See 30 day tab - ones with red background on comments field, those worked. one with purple background is still giving me error even after filtering out blanks. https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf
That could be because there are still duplicate values. You could also delete the duplicate values, but this will also result in a loss of data and you need to be aware of that.