Forum Discussion

anandav's avatar
anandav
Skilled Sharer
7 years ago
Solved

Sorting by multiple columns

Hi Experts,   I have the following data.   Employee Training Date Greg Training 1 19/09/2017 Bill Training 1 19/09/2017 Joe Training 1 19/09/2017 David Training 1 19/09/2017 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    anandav,

     

    You may try using ISONORAFTER Function to add a measure.

    Measure =
VAR t =
    SUMMARIZE (
        ALLSELECTED ( Table1 ),
        Table1[Employee],
        Table1[Training],
        Table1[Date]
    )
RETURN
    COUNTROWS (
        FILTER (
            t,
            ISONORAFTER (
                    Table1[Employee], SELECTEDVALUE ( Table1[Employee] ), DESC,
                    Table1[Training], SELECTEDVALUE ( Table1[Training] ), ASC,
                    Table1[Date], SELECTEDVALUE ( Table1[Date] ), DESC
            )
        )
    )
JustSayJoe's avatar
JustSayJoe
Advocate IV
1 year ago

Step 1: In your Matrix, add a field to the row hierarchy (which you will later remove).

Step 2: Change the Matrix to a Table visual.

Step 3: Sort all the columns you wish to sort, and in the order you wish them to be sorted.

Step 4: Delete the field you previously added in Step 1 from the table.

Step 5: Change the Table back to a Matrix visual.

Step 6: Ensure the right fields are back in the Row hierarchy.

 

This will maintain your multiple sorted fields within your matrix, even when you expand your row hierarchies.