Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Responsive Resident
3 years ago
Solved

Sort Matrix Visual by a field on the table

I have a matrix visual which displays various sales data, counts, average sales, etc.  I created mock data to illustrate the issue in the following pbix:   https://drive.google.com/file/d/1QR9RoQpm...
  • Mikelytics's avatar
    3 years ago

    Hi ConnieMaldonado ,

     

    I might have a small trick to achieve your call. 

     

    Please let the sort column as it is in your picture in the report. We will let it in the matrix but hide it so nobody will see it. For that please do the following.

     

    Default behaviour when you want to hide a column (text wrap in column headers and values)

     

    Step 1) Deactivate word wrap for column headers and values

     

    2) Toggle the column and make it so small that it is gone. 🙂

     

    and further ...

    and gone ...

    I know it is a workaround but it maybe it helps 🙂

     

    Best regards

    Michael

     

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