Forum Discussion

lutho's avatar
lutho
Helper II
5 years ago
Solved

Table visual sort order based on date column not displayed

Ok, I am feeling a bit foolish - this should not be hard.   I have a Table where I need to show the most recent 10 student results. If there are not enough in the present year I wil show prior year...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi,  lutho 

     

    It’s my pleasure to answer for you.

    According to your description, I think you can use 'sort bu column' function in result column.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, lutho 

     

    I think you need to classify the name of the same exam, for example science71, science72, so that there will be no errors.

     

    Best Regards

    Janey Guo

amitchandak's avatar
amitchandak
Super User
5 years ago

lutho , First of check the data type of assessment date, is it date or not. It should be date; if not correct.

In three dots you have option to sort asc and desc. Click on the column name can also change the order.

  • lutho's avatar
    lutho
    Helper II
    5 years ago

    Hi Amitchandrak, thanks for responding and perhaps I have confused the question by showing the AssessmentRecordDate in the image attached. My challenge is that what I actually need to show just the subject line aka:

     

    but sorted in the descending AssessmentDateOrder - without showing the actual date.

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      Could you share the link from where i can download your PBI file.