Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Sort by columns by value in Matrix Visual

I have a table contains ID and Week columns as below ID Week 001 Week1 002 Week2 003 Week2 001 Week3 003 Week3 003 Week3 And I use these 2 to create the Matrix ...
Need Help
Show and Tell
Tips and Tricks
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Hello Anonymous,

     

    This isn't directly supported through standard sorting options, but you can achieve the result by creating a custom measure and using it to sort the matrix.

    SortByWeek3 = 
CALCULATE(
    COUNT('YourTable'[ID]),
    FILTER(
        'YourTable',
        'YourTable'[Week] = "Week3"
    )
)

    Add this measure to your matrix visual (You can add it as a hidden column if you don't want it to be displayed) and sort by the SortByWeek3 measure.

     

    Hope this helps.

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Anonymous 
Unfortunately, this functionality is not available with the core matrix, and I don't believe there are any workarounds to address this.
Please vote on the idea about the issue (I voted):

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=1513f45d-a47a-4326-adbe-8bb0023da6c8

But I free matrix in the marketplace with the needed sorting functionality :

 

You need to get with the mouse cursor to the wanted column and give a right click to see the sort "menu".
From here, the first click will sort the column in descending order and, the second ascending.

The pbix with the example is attached

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