Forum Discussion
Sorting by Index
I am trying to sort the comments in the column Training Recieved Explanation by the completion date, when I tried that it gave me error message below. I then tried to add a index column, and when I try to sort by that, I get same error message. I added my BI file for help. Please see table '30 Day New Hire Survey' I've also looked at how data is set up, I have comments as text and col index as a whole number , please help.
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. 🙂
6 Replies
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. 🙂
