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

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
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

lutho's avatar
lutho
Helper II
5 years ago

Hi Janey, can you please elaborate on "Classify". I understand that classification is for data sensitivity and done in the Service?

The Example Display Result field I use is actually a measure: the Subject (English), the student test result (70) and IF not the current year a bracketed display of the year of the test.

I cannot find any options that make sense.

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

    Hi, lutho 

     

    If you use measure, you can’t see the feature of ‘sort by column’, you should use calculated column, right? Is there only one column in your table visual? Can you share your formula and whether the same value appears in the result column?

     

    Best Regards

    Janey Guo

    • lutho's avatar
      lutho
      Helper II
      5 years ago

      Hi Janey - that confirms why the column was not available for selection.

      The table visual has only 1 column - recent history of exam results.

       

      The DAX query is fairly simple (I am still getting my head around the ins and outs of Power BI):

       

      Exam Display Result = SYN_AssessmentResults[Description] & " - " & SYN_AssessmentResults[AssessmentResult] & IF (SYN_AssessmentResults[Year]<>2020," (" & SYN_AssessmentResults[Year] & ")" )
       
      The purpose of this measure was purely for the display in this one visual. If I need to make is a calculated table happy to do so if that sorts out my ordering issue. Only this measure is used in the table visual.

       

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

        Hi, lutho 

         

        If you use a measure, then you put only one measure in table visual,it will only display one value instead of a list of values.

        Are SYN_AssessmentResults[Description],SYN_AssessmentResults[AssessmentResult] and SYN_AssessmentResults[Year] all measures?

         

        Best Regards

        Janey Guo