Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

Show Most recent comments

I have a list of comments that I would like to display from most recent to oldest.  In my query I have a completion time.  However, some of the comment field at times will be blank and may have repea...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi jcastr02 ,

     

    That is not possible on the table visual as a workaround you can:

    • Create a button with no backgroud and no line
    • Make the button the size of the column header and place it on top of the header
    • Group the table with the header

    That way you will still see the header of the table but if you click on it won't be reorder.

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

MFelix  I tried that earlier too, but I still get same error 😞

 

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

According to your description, you can not sort the [Value] by [Completion Time] due to existing duplicate values.

You can add an index column, and sort [Index] by [Completion Time], when you choose [Value] in visual, try to add this [index] to the visual as well and [Value] will sort by [Completion Time] because [Index] uniquely corresponds to [Value] in table.

 

Best Regards,

Giotto Zhi

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Hi jcastr02 , 

       

      Best option is what you have done in your visualization so placing the comment and index on your table then turn off wrap text on title and sort the table by index then just hide the index column by reducing it's size.

       

      A workaround but it works.

      • jcastr02's avatar
        jcastr02
        Post Prodigy
        6 years ago

        MFelix Yes ! this seems to work!   I appreciate the help.  Only thing I noticed that repeating items such as N/A, pay, the hours, etc. are pushed to the top so everything else sorts except the repeating items, any work around you are aware of?